copy range from one worksheet to another

Hoggle

New Member
Joined
Jan 21, 2008
Messages
43
I'm looking for some VBA that will copy the values held in columns 2-9 in the last filled row of one worksheet to a named destination in another sheet.
I would normally have copied the entire row but if I use this it will over write some formulas in my second worksheet in columns 12 and 13.
Please accept my apologies if code which only needs to be tweaked to meet my needs has already been posted, but I couldn't find it.

Using Excel 2002 and trying to teach myself VBA using Power Programming by JW.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Hello,

If you are trying to teach yoursefl VBA, then I would suggest using the macro recorder to do this, then view it and work out what each line is doing by stepping through the code one line at a time.

I'm sure many people here learned that way.

If you then have any problems, post back.
 
Upvote 0
Hi ,
Thanks for your reply but I've tried the macro recorder and it uses cell references. Will this work using my variable (lastusedrow) for the row reference and -1 etc for column reference?
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,727
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top