in
Questions and answers to issues related to Software: Business, Database, Firewalls, Office, Graphics, Security, System, Server. » Database » 4GL » Btrieve » Excel Macro Error

Excel Macro Error

I have created an excel Macro and it comes up with

Run-time error '91'
Object variabel or with block variable not set.

Looking at it, the column I am checking has calculations in. When I copy an paste as values
and redirect teh search to these columns it works.

Is their anything I can do so it is looking at the value of the calculation. The script is a follows

Sub finder()
'
Dim Quoteno As Integer
Quoteno = 3737

    Columns("A:A").Select
    Selection.Find(What:=Quoteno, LookIn:=xlFormulas, LookAt:=xlPart, SearchDirection:=xlNext).Select
    Row = Selection.Row
    col = Selection.Column
   
End Sub

Solution: Excel Macro Error

It's failing because no range is found.

Instead of LookIn:=xlFormulas, use LookIn:=xlValues

Popular Tags

Browse All Tags