removing format when copying and pasting in VBA

M

monsierexcel

New Member
Joined
Nov 19, 2018
Messages
29
hi all i have a really simple VBA copy/paste b ut cant remove the formatting from it - any ideas please?

Sheets("sheet2").Range("C2:C500").Copy Destination:=Sheets("Totals").Range("A2")
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Hi,
try

Code: 
Sheets("sheet2").Range("C2:C500").Copy
Sheets("Totals").Range("A2").PasteSpecial xlPasteValues
Application.CutCopyMode = False

Dave
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Question Question
copy from source sheet1 to destination sheet2 vba code
Replies
1
Views
250
Vishaal
V
B
  • Question Question
When removing links with copy and paste special some values appear in scientific notation or expanded decimal places.
Replies
7
Views
293
BYahr
B
J
  • Question Question
vba to find specific text in a column and then when found copy all the rows above it
Replies
1
Views
119
mumps
mumps
I
  • Question Question
VBA Script when removing row to a new sheet
Replies
4
Views
144
LongToast
L
V
  • Question Question
Copy Range from Multiple Sheets and Paste Link into a Single Sheet
Replies
2
Views
182
vbascientist
V

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

Share this page

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