copying value from single cell to multiple cells in a range

Hi there,

I have a csv where the date of each item is on top and I need to copy them to the cells that are .offset(-1,2) through .offset(-1,k) to it (where k is the last row of the area) ... This sounds silly, but is there a way to avoid a loop that manually copies 1 cell to another? I'm not a very good OOP programmer.

Thanks.

Its not very clear regarding what you need. Is it possible to post a sample workbook?

eg. Copy value of B1 to A3:A8 ... but A3:A8 has to be specified as an offset from B1.