Return row number as integer 2

[sterlecki]

I would like to return to a variable the row number of the active cell. (say b7)

dim r as integer

r= ActiveCell.address

debug.print r (returns $b$7) I only want the row number

What is the proper syntax?

Just learning VBA in Excel

Thanks

 

[PHV]

And this ?
r = ActiveCell.Row

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

FYI,

Always Define a Row Number variable as LONG instead of INTEGER, since there are 65536 rows in an Excel sheet which exceeds the size of an INTEGER variable.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[sterlecki]

Thanks to you both PHV and SkipVought. Why is it always simpler than I thought?

 

[fumei]

Just as a sidebar, if you are ever setting a variable for the absolute location of a point in a Word document, always declare it as Long, not Integer - for the same reason Skip mentions. The position number jumps to larger than an integer WAAAAY faster than one would think.

Gerry