Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

Row from address of range

Is is possible to extract just the row number from a range address...
so I have E185 in a variable, How can I get just the 185 into a different
variable?
Thanks!!

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
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?	sarah	Excel Worksheet Functions	0	February 17th 09 02:06 PM
How to create a range address with ADDRESS function?	Steve McLeod	Excel Worksheet Functions	1	December 18th 08 02:02 PM
Address Range	[email protected]	Excel Worksheet Functions	5	August 23rd 07 06:07 PM
Deleting Range name's listed in the range address box.	Satnam Patel	Excel Discussion (Misc queries)	4	May 5th 05 01:42 PM
range.address ?	Mark Kubicki	Excel Programming	3	November 26th 03 08:01 AM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us