Excel VBA help

[Leyton]

Hi,

I have created a bit of code that copies a tab and creates a new one, exactly the same but deleting out certain information. The question I have is i want to hide the original tab, but when i do this and run the macro the newly created tab is hidden aswell?

Can you tell me what code i have to write to unhide a tab, also what the code is to unhide certain rows of a workbook?

Thank you

 

[Weaver]

sheets("sheet1").visible=true

will unhide a tab called "sheet1"

range("1:40").EntireRow.Hidden=true

will hide rows 1 - 40

Possibly a bit confusing, since you set the 'visible' property for sheets and the 'hidden' property for cells!

 

[Leyton]

excellent, thank you, sorry I know it was an easy one!