Dim LngRow As Long
Columns("A:A").Select
' You need to do a find and specify what you are looking for before
' you do a findnext I believe.
Selection.FindNext(After:=ActiveCell).Activate
lngRow = ActiveCell.Row
When you are in VBA help looking at the Find method, you can look at the
code example for finding multiple instances (if you are using xl2000 or
xl97).
Regards,
Tom Ogilvy
"Wes Jester" wrote in message
...
I am having a bad time trying to get a row number into a variable. I am
missing something very basic in my understanding.
I have the following code
Dim iRow As Integer
Columns("A:A").Select
Selection.FindNext(After:=ActiveCell).Activate
I can get to the first row I am in interested in, but I need to save the
actual row number in a variable. My next action is to do another search
to find a row further along. I will then have the 2 row numbers to
develop a selection I need.
Wes
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!