Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

dynamic name range in VBA

Hi,

Is this the direct code for assigning a dynamic range to the P column
staring with P2 cell? I keep getting a global name error everytime I call
this NameList range. Thanks for the help.

ActiveSheet.Names.Add Name:="NameList",
RefersTo:="=OFFSET(Sheet2!$P$2,0,0,COUNTA(Sheet2!$ P:$P),1)"

-Vinnie

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 name	Doug Glancy	Excel Worksheet Functions	10	October 26th 06 08:00 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
Excel 2000 VBA - Set Print Range in dynamic range	sub_pop[_5_]	Excel Programming	2	July 27th 04 08:01 PM
Dynamic Range	Tony Reflinski	Excel Programming	2	June 28th 04 11:44 AM
Sum Up Dynamic Range	norika	Excel Programming	7	February 2nd 04 02:11 AM

All times are GMT +1. The time now is 11:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us