VBA: Pasting to a new destination

jzroback · Mar 30th, 2004, 04:58 PM

Hello, I'm a VBA n00b, and I've got (what is probably) a simple problem:

Currently, my macro updates a set of data (in lets say, worksheet 1) (using time), and then copies and pastes special (value) a cell from worksheet 1 into worksheet 2. I currently have it set to paste special into cell C23 of worksheet 2. Everytime I run the macro, I would like it to paste into the next cell down on worksheet 2 (ie C24, and then the next time C25, etc), without me having to manually change the destination each time. Any help would be greatly appreciated!

TIA,
Jesse

Mar 30th, 2004, 04:58 PM	#1
jzroback Join Date: Mar 2004 Posts: 18	VBA: Pasting to a new destination Hello, I'm a VBA n00b, and I've got (what is probably) a simple problem: Currently, my macro updates a set of data (in lets say, worksheet 1) (using time), and then copies and pastes special (value) a cell from worksheet 1 into worksheet 2. I currently have it set to paste special into cell C23 of worksheet 2. Everytime I run the macro, I would like it to paste into the next cell down on worksheet 2 (ie C24, and then the next time C25, etc), without me having to manually change the destination each time. Any help would be greatly appreciated! TIA, Jesse __________________ Jesse "To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the engineer, the glass is twice as big as it needs to be."

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode