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

Joe4 · Mar 30th, 2004, 04:59 PM

WELCOME TO THE BOARD!

Range("C65536").End(xlUp).Offset(1,0).Select

Will select the the first blank cell after the last used cell in column C. Is that what you are looking for?

jzroback · Mar 30th, 2004, 05:02 PM

Thanks for the welcome!

Yeah, that's exactly what I'm looking for. I will give it a try!

jzroback · Mar 30th, 2004, 05:13 PM

Worked GREAT!
Thanks again, jmiskey.

What a cool board!

Joe4 · Mar 30th, 2004, 05:21 PM

You're welcome.

I agree. This is the best user forum I have found on the Web. There are so many experts out here, almost any question can be answered (and in a very timely manner also)!

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."

Mar 30th, 2004, 04:59 PM	#2
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,114	Re: VBA: Pasting to a new destination WELCOME TO THE BOARD! Range("C65536").End(xlUp).Offset(1,0).Select Will select the the first blank cell after the last used cell in column C. Is that what you are looking for? __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

Mar 30th, 2004, 05:02 PM	#3
jzroback Join Date: Mar 2004 Posts: 18	Re: VBA: Pasting to a new destination Thanks for the welcome! Yeah, that's exactly what I'm looking for. I will give it a try! __________________ 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."

Mar 30th, 2004, 05:13 PM	#4
jzroback Join Date: Mar 2004 Posts: 18	Re: VBA: Pasting to a new destination Worked GREAT! Thanks again, jmiskey. What a cool board! __________________ 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."

Mar 30th, 2004, 05:21 PM	#5
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,114	Re: VBA: Pasting to a new destination You're welcome. I agree. This is the best user forum I have found on the Web. There are so many experts out here, almost any question can be answered (and in a very timely manner also)! __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

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