How to copy a sheet and rename it with the value of two cells from the source sheet?

S

Simon Lloyd

Hi all,
I'm trying to copy a sheet as a picture and paste it in to a new shee
(all works well here!) but i also want to rename the sheet using th
text from cell B1 and cell B3 from the source sheet so it can b
identified easily later, here is the code i have but of course doesn
work.......if the text in B1 was Bob and the text in B3 was There the
rename the sheet "Bob There".

is this possible?
The line in blue doesnt work!

Regards,
Simon
Sub cardPicture()
Range("A1:I27").Select
Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture
Sheets("Score Card").Select
Sheets.Add
ActiveSheet.Paste
ActiveWindow.DisplayGridlines = False
ActiveSheet.Select
ActiveSheet.Name = (Sheets("Score Card") Range("B1").Text An
Range("B3").Text)

End Su
 

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

Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Simple Copy to and From Cells With IF statement. 3
how to copy and paste value from one sheet to another 4
Copy a Sheet & Rename based on Cell Value Q 2
Copy worksheet, rename, merged cell problem?? 2
How to copy from each sheet and paste to a summary sheet 2
How to print with a gap in the middle of a sheet 2
Using Sheets.Add after and want to keep a sheet as the first sheet 2

Top