Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

external usenet poster

Posts: 89

Named Ranged, help please

Cell E3 is called "Latest"

In this column I offset to paste vlaues in from other sheets intop the
relvant ow (determined by the offset - could you Lookup I guess).
However do I need to Dim the range to ge tthe following to work?

MyWBAccRep.Sheets("Volumes").Range("Latest").Copy
Destination:=Range("Latest").Offset(0, 1)

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
Named ranged selection problem	Martin B	Excel Worksheet Functions	3	January 4th 08 09:32 PM
Adding Named ranged for each column...	[email protected]	Excel Programming	2	December 1st 06 03:30 AM
Changing a named ranged based on array size on a form	Wanderer[_2_]	Excel Programming	2	June 27th 06 01:10 PM
Vlookup - Using a named ranged for col_index_num	[email protected]	Excel Discussion (Misc queries)	2	June 1st 05 05:38 PM
Counting in ranged intervals	No Name	Excel Programming	2	April 12th 04 07:39 PM

All times are GMT +1. The time now is 05:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us