How To Insert Page Numbers In Excel
The folowing code is used to auto define the header/footer while plotting an excel worksheet to pdf Only thing that doesn't seem to work is the centerfooter function, it's supposed to give "active sheet name defined date in ddmmyyyy format (value of cell Sheets("instellingen")Cells(22, 2) ), this results only in returning the date in format "mmddClick the Sheet Name button (2) – the code &Tab is added to the Center section;
