Does anyone know how to achieve the following (as my do loop contstructions
are taking quite a while to execute and this would be far faster I am sure).

Column A contains dates which expand by one each day (funnily
enough). Basically I want to copy the dates from one sheet to another as
fast as possible, and then copy a column of numbers into the adjacent column
(I wnat to copy one column over each time so offset will probably do me when
I
get the syntax).

My idea is to define the column of dates as a named range
and then just say "the same range on sheet B is to equal the named range on
sheet A"
the idea being that just picking up the dates as a block and plonking them
in the destination sheet is likely to be quicker than assigning the values
one at a time as i do now using a do loop construction.

Would appreciate any pointers, kind regards, Mark