Shorter Code

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Is there any way I can make the following a bit more code efficient?
Thanks in advance
Sandy

Sheets("Chart Data").Select
ActiveWindow.DisplayHeadings = True

Sheets("Info").Select
ActiveWindow.DisplayHeadings = True

Sheets("Chart Data2").Select
ActiveWindow.DisplayHeadings = True

Sheets("Chart Data3").Select
ActiveWindow.DisplayHeadings = True

Sheets("Chart Data4").Select
ActiveWindow.DisplayHeadings = True

Sheets("Chart Data5").Select
ActiveWindow.DisplayHeadings = True

Sheets("Chart Data6").Select
ActiveWindow.DisplayHeadings = True

Etc Etc
 
for each sh in worksheets
sh.Activate
ActiveWindow.DisplayHeadings = True
Next
 

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

Unhide rows error 2
auto enable macros 5
DisplayHeadings 7
Stripping down excel 2
If Sheet Exists Q 6
Workbook_BeforeClose 3
ThisWorkbook coding problem... 1
Weird error code..."400" 14

Back
Top