Posted to microsoft.public.excel.programming

Greg[_21_] Greg[_21_] is offline

external usenet poster

Posts: 8

Copy via code from a dynamic range using offeset

Hi out there,

Can someone help me with the syntax to refer to a dynamic range via
code?

I am trying to use activesheet with the following parameters:

- Start copy at cell CI6 (including CI6)
- Go down rows via value in cell CI2
- Past values to cell G6

TIA,

Greg

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
macro code to get dynamic range	ashish128	Excel Discussion (Misc queries)	3	June 15th 07 02:41 PM
Dynamic Range Offset causing problem with this code	Arishy[_2_]	Excel Programming	1	August 3rd 05 06:15 PM
Dynamic range copy.	sungen99[_22_]	Excel Programming	1	June 10th 05 04:44 PM
Code to copy range vs Copy Entire Worksheet - can't figure it out	Mike Taylor	Excel Programming	1	April 15th 04 08:34 PM
dynamic range reference and use of common code	clui[_4_]	Excel Programming	2	December 2nd 03 05:45 PM

All times are GMT +1. The time now is 03:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us