Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

setting Range from address

Hi,

Depending on the value of Range("a1"), a range address is stored in
Range ("b1") as follows: Master!$B$31:$B$52. How can I use the value
in Range("b1") to set a range in vba code?

Any other suggestions also welcome.

Thanks in advance for the help.

Regards,
Raj

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
How to create a range address with ADDRESS function?	Steve McLeod	Excel Worksheet Functions	1	December 18th 08 02:02 PM
getting the absolute range address from a dynamic named range	junoon	Excel Programming	2	March 21st 06 01:29 PM
setting range().hidden=True causes range error 1004	STEVE BELL	Excel Programming	6	September 2nd 05 02:16 AM
Is there a template for setting up a address book?	Jace	Excel Discussion (Misc queries)	1	August 22nd 05 03:42 AM
Setting a variable cell address	Hugh Jago	Excel Discussion (Misc queries)	3	January 5th 05 03:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us