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