Macro to copy rows 1:6 to a new workheet after active sheet and paste only values.

[catscats11]

Hi.

I am try to create a macro that copy the data from rows 1:6 on Sheet1 and paste only values (no functions,formulas,etc.) to new sheet after Sheet1. Should make a new sheet everytime so everytime i run it, it will create a new sheet and the values will be saved. If possible i want to name the new sheet what the contents are in cell B2.

I keep running into issue when i try to name the new spread sheet the contents in B2. I can copy values too, but it keeps functions and therefore defeats the purpose why i want to paste only values in new sheet. if someone could write a VBA code for what I am trying to do, you will make my day!!! Thanks in advance for any help!!!

[Mumps1]

Try:

Please Login or Register  to view this content.

Make sure you change the value of B2 before each time you run the macro.

[AlphaFrog]

Please Login or Register  to view this content.

[catscats11]

Sorry for getting back to you so late... Thanks for such a quick response!

Worked like a charm! thanks man!

[catscats11]

thanks for adding the msg box upon error. didn't even think to do that either.... its the little things. lol

Thanks. will be adding a msg box for err as well.

everybody in these forums are amazing.