MrExcel Publishing
Your One Stop for Excel Tips & Solutions

In VB - Find Command

Posted by Kevin on February 21, 2001 5:29 PM

I want to find a certain value in column A:A.

Then store that row refernce in a variable.

Posted by David Hawley on February 21, 2001 9:37 PM

Dim RowNum As Long
RowNum = Sheet1.Columns(1).Find(What:="Carrot", After:=[a1]).Row

OzGrid Business Applications