Pulling out numeric number from Activecell.Address

[WLMPilot]

I need to get the numeric value of Activecell.Address into a variable so that
I can do calculations. Example: ActiveCell.Address = $F$426. I need to
pull out 426 and place in a variable.

How can this be accomplished?

Thanks,
Les

 

[Norman Jones]

Hi Les,

Try:

Dim i As Long

i = ActiveCell.Row

 

[JLGWhiz]

Hi Les, The 426 is the row number so you could use:

myVar = ActiveCell.Row

That would give you an integer value for the row number.

 

[WLMPilot]

Thanks.

Les

Hi Les, The 426 is the row number so you could use:

myVar = ActiveCell.Row

That would give you an integer value for the row number.

 

[WLMPilot]

Thanks.

Les

Hi Les,

Try:

Dim i As Long

i = ActiveCell.Row