Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing question
I have a print macro question. I have a cell that says for example "Print Row"
Print Row = 1 (call this cell A2) Rows: 1 (A5) 2 (A6) 3 (A7) 4 (A8) blank after A8 How do I get the cell where Print Row = 1, to change to 2 then 3 then 4 and then back to 1 once it hits the blank row? Hope this makes sense, I'm trying to get my print macro to cycle through to only populated rows, then stop. I have my template formula based, so all I want it to do, is to start with 1, print the report tab, then go to 2, print the report tab, go to 3, print the report tab, go to 4, print the report tab then there are no more records so it should stop and reset itself to 1 so when you hit the button again, it would cycle back through. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Discussion (Misc queries) | |||
Printing question | Excel Programming | |||
Printing Question | Excel Discussion (Misc queries) |