Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find method
benb wrote:
I want to search an entire sheet for a cell containing a value then return the column number for that cell. I have tried variations of n=Activesheet.Find ([value], LookIn: xlValues, LookAt: xlWhole).Column, but any adaption I try gets a compile error. Any help? Three changes will fix your code: n = Activesheet.Cells.Find ([value], LookIn:=xlValues, LookAt:= _ xlWhole).Column Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Find method | Excel Programming | |||
The find method | Excel Programming | |||
Help with the Find method | Excel Programming | |||
The Find Method | Excel Programming | |||
The Find Method | Excel Programming |