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

--
sb
"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!