|Subject:||Excel 2003 - VBA - Determining location of activecell|
|Posted by:||Craig Brandt (brandtcra…@att.net)|
|Date:||Tue, 15 Jul 2008|
I am running into the preverbial wall. I keep reaching a dead end when I try
to figure out how to locate the address of a cell found during a search.
I'm fairly sure it can be done, because I think I have used it in the past,
but searching for its use has been fruitless.
Is there something that I can wrap around the following statement that will
give me the column number? If so, what?
Range(Cells(5, 7), Cells(5, 251)).Find("SAM501").Select
The answer to this quest will permit me to finish this task and would be