LinkBack URL
About LinkBacks
Hello,
I need to paste only the format and formulas of a copied range. I used the code below, but it is pasting the values too in the cells.
Can anyone help please.
Please Login or Register to view this content.
thank you
Hello,
I need to paste only the format and formulas of a copied range. I used the code below, but it is pasting the values too in the cells.
Can anyone help please.Please Login or Register to view this content.
thank you
Maybe something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you for the help, It worked, but it also deleted the header i had.
Try this to keep the row 1 headers.
ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeConstants).ClearContents
Or this to define a spcific range to clear.
ActiveSheet.Range("A2:Z100").SpecialCells(xlCellTypeConstants).ClearContents
Last edited by AlphaFrog; 05-23-2014 at 11:59 AM.
Thank you so much for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks