Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Title Columns Print Issue
Hi all,
I am looking to print out multiple pages with title columns. My worksheet has employees 1 to 100, each employee occupying a single column... the title columns are fixed, (ie. column A). I am using some code which does a test on a row and picks up the last used column... There is a defined range called first cell and the print range is the range from the first cell to the last used cell which is dynamic depending on whether data is entered for that employee... anyway... i've been experiencing this issue with printing... the title columns appear to be the cause... when i go to print out 1 or 2 pages it seems to be fine however if i print several pages then... it will only print out 2 to 3 pages opposed to just say... 5..... i don't understand why this is happening and it seems to be a bug in excel because the code is picking up the correct print range.... i've also checked the page setup.... has anyone else come across a similar issue with printing? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Really strange issue with simple formula | Excel Worksheet Functions | |||
Strange named range issue with multiple workbooks | Excel Discussion (Misc queries) | |||
Strange Calculation issue | Excel Discussion (Misc queries) | |||
Really Strange Excel Issue | Excel Discussion (Misc queries) | |||
Strange color issue | Excel Discussion (Misc queries) |