You're right it works. I must have copied it wrong. Next problem, if I have a table with 1000 rows say which is divided into sections, e.g. 1 to 100, 101 to 200, 201 to 300,.........901 to 1000. They are all in the same worksheet, one below another.
In each of the sections I have hidden rows, e.g. rows 5 to 100 are hidden, rows 121 to 200 are hidden, rows 209 to 300 are hidden etc., .....rows 909 to 1000 are hidden.
Is it possible to use the unhide macro in each of the separate sections to unhide the next hidden row in each section. I tried inserting the same macro in the next section down but all it does is unhide the next row in the first section each time.
I need each macro to refer to the section it is included within, i.e. the macro needs to be applicable to a range of rows only.
Thanks
Graham