Drmwvr7266
Board Regular
- Joined
- Apr 7, 2002
- Messages
- 164
I have sheets that are laid out in both portrait and landscape. By dumb luck I suppose, all sheets from #1 to #34 are landscape, and all sheets thereafter will be Portrait. This requires some thought for printing. However, I just need a small snippet of code to complete the code.
If activesheet is between sheet1 and sheet34 Then
Macro1
Else
Macro 2
End If.
How do I select this range, and if I should need to modify it, how would i change it? Change it meaning:
If active sheet is sheet 1,2, 3, 6, 7, 10 Then
Macro1
Else
Macro2
End If
Thanx in advance. This site has been as good as a second education! Who needs college anymore when we have the INTERNET!
If activesheet is between sheet1 and sheet34 Then
Macro1
Else
Macro 2
End If.
How do I select this range, and if I should need to modify it, how would i change it? Change it meaning:
If active sheet is sheet 1,2, 3, 6, 7, 10 Then
Macro1
Else
Macro2
End If
Thanx in advance. This site has been as good as a second education! Who needs college anymore when we have the INTERNET!