Dynamic Range Query

I'm looking to set up a dynamic range that spans the range C5:G20 on a sheet. Additional rows of data will be added hence the requirement for the dynamic range. I've established that I can create a dynamic range for one column (C) but I'm struggling to set this up for the required area of the spreadsheet. I'd be grateful of any help

Here's the code I have at the moment

Please Login or Register  to view this content.

Many thanks in advance

M

Many thanks for your help TMS. I've taken your code, modified it slightly to reflect actual columns on my worksheet but i'm not sure that it's working. The aim of the code is to list all the worksheets in a workbook, identify which ones are hidden/protected and list them on the worksheet. The code works if I define a range in code the usual way but not when adopting the dynamic range approach. Heres the code

Please Login or Register  to view this content.

Hi TMS, all sorted. I was missing the ' before and after the sheet name in the formula. Many thanks again for your help, I've been putting this off for a while because of this issue...onwards and upwards now!!