Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Row Number
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Row Number
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Row Number
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining row number in which a value occurs | Charts and Charting in Excel | |||
Determining the highest number in a row | Excel Discussion (Misc queries) | |||
Determining the highest number in a row | Excel Discussion (Misc queries) | |||
Determining Active Row Number | Excel Programming | |||
Determining Active Row Number | Excel Programming |