Dynamic Name Range using VBA

Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Dynamic Name Range using VBA

Hi,

I need to create sheet level Dynamic range names in a workbook using
VBA.. This is what I insert in the RefersTo box while creating a name
manually:

=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B$3:$B$500) ,1)

How do I do it in VBA?

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
dynamic range based on criteria, within a dynamic range, passed to a function	[email protected]	Excel Programming	5	October 9th 07 10:13 PM
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function	[email protected]	Excel Programming	0	October 9th 07 05:22 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
select dynamic range with dynamic start point	Juli	Excel Programming	1	August 31st 05 12:05 AM
Excel 2000 VBA - Set Print Range in dynamic range	sub_pop[_5_]	Excel Programming	2	July 27th 04 08:01 PM

All times are GMT +1. The time now is 09:40 PM.

Menu

About Us