MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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


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


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".