Hi there,

Ive been building an excel spreadsheet for a little while and have come stuck on something.

I need a macro button which adds 7 days to a date. I have a whole column of dates (column E), and I want
the macro to go through each cell in Column E and add 7 days to a date in each cell. Some cells are
blank and do not have dates, so I want them to be ignored.

I know that this sort of thing can add 7 days to a date in a particular cell:

Range("E2").Value = Range("E2").Value + 7

But I'm stuck how to do it for a whole column and to ignore cells if they are blank.

I'm really looking to expand my VBA skills so any help would be greatly appreciated.

Regards,

Jake