Determining Row Number

  • Thread starter Thread starter Wes Jester
  • Start date Start date
W

Wes Jester

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
 
Wes,

Your Find needs a What

Columns("A:A").Select
Selection.Find(What:="mywhat", After:=ActiveCell, _
LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:= _
False).Activate
myrow = ActiveCell.Row

repeat for myrow2
 
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
 
Back
Top