Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Activecell if it is not numeric | Excel Programming | |||
How can i get activecell address | Excel Programming | |||
identify the name of the activecell not its address | Excel Programming | |||
Activecell address | Excel Programming | |||
ActiveCell.Address | Excel Programming |