VBA Choose Another Column If Next is Empty

[sanjeevpandey]

Hi,

I am comparing two columns and deleting the unique row if found in any of them. I compare columns A and C. However, sometimes it it possible that column C will be empty so I'd like to choose column D instead to compare with the column A. How can I do that? I tried the if condition but the code gets stuck in the loop. I first compare each row of column C with entire column A and delete unique, then compare each row of Column A with entire Column C and delete the unique if found. Here is the code:

Please Login or Register  to view this content.

The objective is to select Column D if the column C is empty, else continue with Column C. I'm stuck on this

Thanks!

[arlu1201]

Is the above code working? Then add the elseif condition in this code piece and use D.

Please Login or Register  to view this content.

[Alf]

You could check the value of "Last" something like

Please Login or Register  to view this content.

Or you could use CountA i.e

Please Login or Register  to view this content.

Alf

[sanjeevpandey]

Thanks arlu1201, the above code works perfectly if I choose a particular column. However, the trouble has been to choose another if C is empty