Finding the start of a row

Posted by Lewis on December 07, 2001 2:35 AM

I have data in a number of rows and columns. I wish to search for a particular value (which I can do) having found it I wish to go to the first cell in the row in the A column.
Any suggestions

Regards
Lewis

Posted by Bariloche on December 07, 2001 5:18 AM

Lewis,

You want to use a line of code similar to the following:

ActiveCell.End(xlToLeft).Select

Depending on whether you've selected your "found" cell (and thus its the "activecell) or not. If not, then just substitute the range reference of your "found" cell in place of "activecell".

enjoy