KlausW
Active Member
- Joined
- Sep 9, 2020
- Messages
- 378
- Office Version
- 2016
- Platform
- Windows
Hi, I use this VBA code to print a sheet with but it does not work. Now I want Excel to print the number of pages (A4) that are in cell E1.
All help will be appreciated.
Regards Klaus W
All help will be appreciated.
Regards Klaus W
VBA Code:
Sub Lukaf_Rektangelafrundedehjørner1_Klik()
Dim intRaekke As Integer
Dim SidsteSide As Integer
SidsteSide = Sheets(intRaekke).Range("E1")
Sheets(intRaekke).PrintOut From:=1, To:=SidsteSide
End If
Next
End Sub