Posted to microsoft.public.excel.programming

WLMPilot

external usenet poster

Posts: 470

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

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 07:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us