Macro / VBA adjusting variable columns

[Guest]

I've been set the task of taking 4 spreadsheets and making them more
automatic, i've done 3, but the 4th is proving difficult.

Down the left hand side are tasks, and along the top are the dates. The
first column of data (data, not the sheet, A and B contain the tasks) then
the print area needs moving on 1 column. All the information can be taken
from another spreadsheet apart from the date at the top which should be the
last working day.

For a bit more information, today I hid column BT and extended the print
area to column CI, I then put 18/04/06 at the top and copied the information
over. Tomorrow I will hide BU and extend to CJ, putting the date as 19/04/06.

How can I hide the first column of data (the 3rd unhidden) and extend the
print area 1 column in a Macro?

Cheers!

 

[mrice]

Have you tried recording a macro to do this - it will give you an idea
of the necessary syntax.