About Us

I need to write a line of code in a VBA macro for Excel that says "copy the contents of the current cell to column H in this same row." I am trying to do this as I traverse through a range of cells R (which represents a column). I have tried to use R.copy(destination), but I don't know what to use for the destination parameter to accomplish my goal. The task is simple but i'm new to Excel macro programming. Can anyone help?

--
Message posted via http://www.officekb.com

Joe

If the column is say A, you could use

r.Copy Destination:=r.Offset(0,7)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Joe E via OfficeKB.com" wrote in message
...
I need to write a line of code in a VBA macro for Excel that says "copy the
contents of the current cell to column H in this same row." I am trying to
do this as I traverse through a range of cells R (which represents a
column). I have tried to use R.copy(destination), but I don't know what to
use for the destination parameter to accomplish my goal. The task is
simple but i'm new to Excel macro programming. Can anyone help?

--
Message posted via http://www.officekb.com

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate which cells in column A will give me the total of column	Ken	Excel Worksheet Functions	4	January 6th 05 06:25 AM
How do I ROUNDUP a Column of cells on a worksheet template?	house mouse	Excel Worksheet Functions	2	December 16th 04 06:49 PM
how to copy 2350 hyperlink full paths to any column in a worksheet ?	kontiki	Excel Discussion (Misc queries)	4	December 10th 04 10:00 PM
Copying the contents of a column into a chart	Richard	Excel Worksheet Functions	1	November 16th 04 02:39 PM
copy group of cells to another group of cells using "IF" in third	Chuckak	Excel Worksheet Functions	2	November 10th 04 06:04 PM

Menu

About Us