VB Code Help with Excel.

[Faithless]

Hi all,

I need a copy command in an Excel sheet that copies the cell contents not the cell formating.

At the minute, when the active sheet is chosen and its range Range("A1") for instance. I want JUST the cell contents to be copied.

The cell in question as a Orange border around it and that seems to copy over too. This, I do not need, as said, just the cell contents.

Thanks

 

[Faithless]

Thanks, All I needed to do was use the paste special command and choose value.

Another thing. The two sheets I'm pasting between are both password protected. As it stands now, in order to paste between the two sheets I have to manually enter the password twice. Is there a way to get around the manual passworld typing?

Thanks again