I want it to just hide the row.
I am very grateful for both your reponses, so thank you and please be patient if I seem thick, I'm not I'm just new to macro's and programming.
Backround... I'm head of maths in a school (no I'm not striking, but I've got no kids in today to teach as lots of people are).
I have spreadsheets which have details on pupils weak areas. Topics and revision references across the top.
Pupils names down the left with lots of individualised data as youp read across for each pupil.
Normally when I provide this info to my pupils I select everything across the top and just the first pupil. I then click Ctrl p and send this to the printer (set the printer up to print selection and scale to page).
I then hide the first pupil and repeat the select and print for the next pupil, then hiding them and printing the next pupil and so on. Once I've set the printer after the first one it is set until I close the document so I only have to do this once.
About half an hour later, all of our year 11's have individualised target areas with referenced revision material... but the printing is a right ball ache.
If I had a macro I could literally press ctrlp return ctrl and whatever key the macro is set up to over and over until they are all done. Would take 90 seconds to print all of them.
Any help greatly appreciated as I have today to get this sorted.