Dear Jerry,

Thanks for the pointer. Seems like we cannot have best of both worlds. I am thinking of writing a macro to "dynamically" change the range whenever a new data is being dumped into the worksheet (using worksheet_deactivate)

Cheers & Thanks you once again,
CL