I have a couple of problems for which any help would be greatly appreciated.
I have several workbooks where I have to amend the page number on each
spreadsheet. The page numbering does not necessarilly start on the first
spreadsheet so my first thought was to have an Input Box in which the start
position could be entered and for this to loop through the remaining sheets.
My first problem is that I can't get it to loop. Secondly, I wish to use the
&tab as a page footer which I have managed so long as I enter the array of
sheets to be formatted. Is there a way I can use the worksheets.count from
earlier in my code to fill this array or some other way? I have pasted my
code below. Many thanks.