Posted to microsoft.public.excel.programming

Mike[_101_] Mike[_101_] is offline

external usenet poster

Posts: 5

How do you have range address

I need to have the user select a range of cells, click a button to run a
macro, select another range and click another button to run another macro.

I need to save the address of the original range that was selected for
reference in the second macro. What would be the command syntax to save the
address of the initial range so I can reference it again.

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
Row from address of range	KyWilde	Excel Programming	3	April 22nd 05 08:07 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us