Excel 2003 - VBA - Determining location of activecell

Giganews Newsgroups
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
much appreciated.

Thanks,
Craig

Replies