Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following macro which I recorded (I am not knowledgeable in VBA).
Sub Print1() Sheets("Buyer List").Select Range("A1:G15").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("A1").Select Sheets("Main").Select End Sub From the worksheet named Main, it goes to the Buyer list worksheet, selects the range A1:G15 and prints. Then goes back to Main. The problem is that I get a far larger range printed and for the life of me, I can not figure out why. It actually prints A1:L225 Any guidance will be appreciated. Thank you. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro not working properly when run automatically | Excel Discussion (Misc queries) | |||
Macro is not working properly | Excel Discussion (Misc queries) | |||
But not working properly | Excel Discussion (Misc queries) | |||
Macro not working properly when the file is shared | Excel Worksheet Functions | |||
Macro "1 tall/1 wide" not working properly | Excel Worksheet Functions |