Prevent Cell Format being copied by copy command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

Is it possible using VBA to prevent the format of a cell
being copied from one cell to another when the copy
command is used?

ie. I have a spreadsheet with formatting only in column
A and I do not want the formatting of column A to be
copied if a user select control C or edit copy from
column A and than pastes the value in column B. I want
the user to be able to copy the value just not the
formatting.

Any assistance would be appreciated.

Thanks
 
Just use Paste Special to just paste the values?

Selection.PasteSpecial Paste:=xlValues

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
conditional format fails when copied 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy columns and paste with blank column between 5
Copy value from changing cells without VBA 1
Copying a formula to a range 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top