Error handling when dynamic name range is empty

Greetings,

The below macro creates a third list by concatenating two lists (Dynamic Ranges "Test" & "DB"). There could be three (which I can think of) situations that causes the code to error out.

1. Both Test & DB are empty - Nothing to be done
2. Test is empty but DB is not - Third list to be equal to DB
3. DB is empty but Test is not - Third list to be equal to Test

I tried to put in some error handling but it is not working as expected under different scenarios - I populated a range of cells with the values of the third list. Can someone please help me?

Much appreciated
Asha

Please Login or Register  to view this content.

Hi Leith,

Thanks for your prompt response. Sorry to say this but when both DB & Test ranges are empty, I get a run-time error 1004: application defined or object defined error with the following code highlighted in yellow

Please Login or Register  to view this content.

Any ideas why this is happening?

Many thanks
Asha

Hi all,

I have taken another stab at this and it seems to work but I am not sure if this is a very robust & efficient as I ended up writing additional code for three separate processes depending on the scenarios!

Any suggestions in cleaning up the code would be greatly appreciated.

Thanks again
Asha

Please Login or Register  to view this content.