Secondly, I am trying to record and run a macro on an audit spreadsheet showing operator activity.
The first issue which I have sorted is skinning down the report to only those rows that have record changes on the database (this was done by an ‘if’ statement and an auto filter command in the macro).
The second issue is to get the sheet to fit perfectly as 1 page wide by X (blank) pages tall. However I cannot do this. After the table is skinnied down, the printing macro (whether separate or the second part of the macro command) still includes all the (now) blank rows from where the whole sheet used to cover. It’s like Excel doesn’t realise that these are no longer active cells. Is there any way around this, so I can get Excel to realise only the rows with data are active?
Btw, I have tried recording a printing parameters macro in every way possible, i.e. Selecting all cells and then trying to fit it with page set up, selecting cells by Ctl-down and ctl-across and many other methods) and it still recognises the old, now blanks cells as active. Any idea how to get round this?