ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   run time error '91' (https://www.excelbanter.com/excel-programming/309463-re-run-time-error-91-a.html)

Bob Umlas[_3_]

run time error '91'
 
Means it couldn't find what you were searching for!

"tina" wrote in message
...
My problem is I recorded a macro with find in but when i ran it later I

get
error message "object variable or with block variable not set"

the part of macro it errors on is as follows
Selection.Find (What:="*/07/04 00", After:=Activecell, LookIn:=xlValues,

_
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate

when recording it works fine
Any ideas would be much appreciated
Thanks
Tina





All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com