Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and select a cell
I am looking in column A for a specific Phrase and I want to make that the
active cell so I can perform an essbase zoom in, I am using this code but it doesn't want to work any suggestions For r = 1 To rngB.Rows.Count If ActiveSheet.Cells(r, 1).Value = "Arc Accesories" Then Set rngTemp = ActiveSheet.Cells(r, 1).Range("A1:A1") x = EssMenuVZoomIn End If Next r Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use find to select entire rows with a cell with that value | Excel Worksheet Functions | |||
Find text in a cell and select whole row question | Excel Programming | |||
find highest number then select next cell | Excel Programming | |||
Find cell select row and delete | Excel Programming | |||
Find a certain word in excel and select the cell | Excel Programming |