Pulling out numeric number from Activecell.Address
 

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

Pulling out numeric number from Activecell.Address
 

Hi Les,

Try:

Dim i As Long

i = ActiveCell.Row




---
Regards.
Norman


"WLMPilot" wrote in message
...
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

Pulling out numeric number from Activecell.Address
 

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" wrote:

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