still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
hi
I have a userforn that i use to print different pages.
The macro looks like this >>shorten to same space<<
case is goes to "Z"
Sometimes I have to change the page numbers>>From:=1, to:=2.... to say 3 or 4
then I have to adjust the printout
Could I instead use a Range? and How? Range A, Range B, etc. and have the "printout" do the entire range
I can then change only the range on the sheet. It would seem to be easier.
mike
I have a userforn that i use to print different pages.
The macro looks like this >>shorten to same space<<
VBA Code:
Select Case Me.ListBox1.Value
Case Is = "A": ActiveSheet.PrintOut from:=1, to:=2, copies:=1
Case Is = "B": ActiveSheet.PrintOut from:=4, to:=5, copies:=1
Case Is = "C": ActiveSheet.PrintOut from:=7, to:=8, copies:=1
Sometimes I have to change the page numbers>>From:=1, to:=2.... to say 3 or 4
then I have to adjust the printout
Could I instead use a Range? and How? Range A, Range B, etc. and have the "printout" do the entire range
I can then change only the range on the sheet. It would seem to be easier.
mike