Hi Sorry for delay in replying after you took the trouble to respond...

Ok, I have a macro which looks in a table and places the data into a format for printing selected records into a A4 template. Currently I input "Y" into a cell at the front of the table so the macro includes that row of data in the results. If the checkbox is checked I want the macro to run on that row of data.

If the checkbox is not checked, I want the macro to ignore that row (i.e. at present when cell is left blank). The macro runs on the active sheet, i.e. I can run it from any of 20 different worksheets.

Thanks