Posted to microsoft.public.excel.programming

Steve[_4_] Steve[_4_] is offline

external usenet poster

Posts: 184

Add to Dynamic Named Range

Hi all. I have a dynamic named range in Sheet1 A2:A100. I would like
to call a macro to pop an input box asking for a new value, and then
write that value in the next available cell in my named range. Any
idea how I can accomplish this?

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
Dynamic Named Range	dhstein	Excel Discussion (Misc queries)	4	October 11th 09 11:15 PM
Dynamic Named Range	Madiya	Excel Programming	7	August 14th 06 02:19 PM
Dynamic Named Range	bountifulgrace	Charts and Charting in Excel	1	April 6th 06 08:39 PM
getting the absolute range address from a dynamic named range	junoon	Excel Programming	2	March 21st 06 01:29 PM
dynamic named range	Steph[_3_]	Excel Programming	3	March 22nd 05 02:56 PM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us