Posted to microsoft.public.excel.programming

Brad

external usenet poster

Posts: 846

Question for Jim Thomlinson

Thank you for pointing out that I should use the code name - rather than tab
name - how would the following code be change to use code name - rather than
tab name?

Sub Print_pages()
Dim sht As Worksheet
For Each sht In Worksheets
If sht.Name < "Input" And sht.Visible = True Then
sht.PrintOut
End If
Next
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Thanks Jim Thomlinson	april	Excel Discussion (Misc queries)	2	April 16th 08 04:56 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 27th 05 07:46 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	23	April 23rd 05 09:26 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 22nd 05 03:30 PM
? for Jim Thomlinson	JT[_2_]	Excel Programming	0	February 3rd 05 07:33 PM

All times are GMT +1. The time now is 11:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us