copy/paste

[jarhead58]

Why wouldn't this code work in a macro activated by a command button! It copies the cell to the clipboard but won't finish with the paste! Stumped!!

P.S. Button is on active cell sheet.

Worksheets("Sheet1").Range("N2").CopyActiveCell.PasteSpecial Paste:=xlPasteFormats
ActiveCell.PasteSpecial Paste:=xlPasteValues

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...-copy-and-paste-with-formats.html#post4980338

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[jarhead58]

Cross posted https://www.excelforum.com/excel-pr...-copy-and-paste-with-formats.html#post4980338

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

I just got antsy, I'm impatient to a fault and as this happened, I need to contain it! My apologies!

 

[jarhead58]

I just got antsy, I'm impatient to a fault and as this happened, I need to contain it! My apologies!

Are we good?

 

[Fluff]

As long as you abide by the rules, yes

 

[jarhead58]

Will do!!

 

[jarhead58]

In that case is this what you want

Worksheets("Sheet1").Range("N2").Copy
ActiveSheet.Paste

Disreard this post please, I was using an older ver of the spreadsheet.

 

[Fluff]

None, it already does that.

 

[jarhead58]

I know, gotta delete the older versions. I need to stop, it's got my brain hurting lol!