Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find in Recorded Macro
I cannot seem to identify the mistake is this recorded (and edited) macro.
Thde query text will appear in cell B1. Would appreciate assistance. Thank you. Sub Macro1A() Cells.Find(what:=.Range("B1").Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub -- Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find in Recorded Macro
You have a "dot" in front of the Range reference, but you don't have a With statement for it to reference back to. Try removing that dot and see what happens. -- Rick (MVP - Excel) "Robert" wrote in message ... I cannot seem to identify the mistake is this recorded (and edited) macro. Thde query text will appear in cell B1. Would appreciate assistance. Thank you. Sub Macro1A() Cells.Find(what:=.Range("B1").Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub -- Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find in Recorded Macro
Thanks Rick. I thought I tried all permutations. -- Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Recorded single column insert in macro. Macro inserts two not one | Excel Programming | |||
Recorded Macro | Excel Programming | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
Recorded macro won't run | Excel Programming |