Dynamic Range?

[lgroulx2000]

Hi,
I want to set a Dynamic Range. I like to be able to add new rows and columns.

What I have is a construction schedule that displays dates. There is a Tasks list in column A that has some blank spaces. The dates start in column B. When a new job is added (a new column), the only cell displaying a date will be row 4.

Thanks,

Larry

[royUK]

You don't need VBA to do this, see this