Posted to microsoft.public.excel.programming

JLGWhiz

external usenet poster

Posts: 3,986

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Activecell if it is not numeric	FIRSTROUNDKO via OfficeKB.com	Excel Programming	3	April 11th 08 02:57 PM
How can i get activecell address	Bond S.C	Excel Programming	7	August 1st 05 10:24 AM
identify the name of the activecell not its address	RogerTheDodgerTheDirtyOldSod	Excel Programming	2	September 26th 04 09:53 PM
Activecell address	Patty2005[_4_]	Excel Programming	2	August 7th 04 03:58 AM
ActiveCell.Address	Todd Huttenstine	Excel Programming	3	July 27th 04 04:45 PM

All times are GMT +1. The time now is 04:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us