Help with Macro - copy worksheet
I found a Macro that creates a new sheet and copies information form another worksheet. I need it to copy the formatting from the old sheet to the new sheet. It copies the information just fine, but it needs to copy the format too. Any help that could be provided would be greatly appreciated.
I think this might work
Sub CopyWS() Dim WSName As String Worksheets("CopyFrom").Copy Before:=Worksheets(2) WSName = InputBox("Worksheet Name") ActiveSheet.Name = WSName End Sub
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
I tried it, but it didn't work. It still copies without formatting. Thanks anyways.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks