View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default 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