Sir Babydum GBE
01-23-2008, 03:58 AM
Hi,
I have a sheet where the headers are in row 5 Columns A to L, data starts in row 6, the problem is any column could contain a few blank cells.
How do I do a dynamic range that starts in A5, and takes me to column L - to the last row with any data in it please?
Thanks
BD
I have a sheet where the headers are in row 5 Columns A to L, data starts in row 6, the problem is any column could contain a few blank cells.
How do I do a dynamic range that starts in A5, and takes me to column L - to the last row with any data in it please?
Thanks
BD