Hey everyone,
I had a dynamic named range which started at top of myworksheet (row 2) and I decided I would like to move this range down to row 36 and use the top of my worksheet for something else. Then the named range got weird...
My original dynamic named range was as follows:
I modified it to the following so that whatever I include in the top rows doesn't get counted in the dynamic range:
For some reason, when I test out the new named range above, it suddently turns into the following formula (or some variation of this):
Any idea why this is happening?? I don't get it... I just want a dynamic named range to begin a little further down in worksheet.
Thanks for any help you provide,
Geoff.
Bookmarks