How to run multiple subs in multiple ranges within a worksheet

**roshanvmech** · 03-05-2014, 11:55 AM

Hi All,
I have a worksheet divided into 4 quadrants. In each quadrant for a selected range, I have to perform the below activities.
In Q1 (A4:B23): All the empty cells should go at the bottom. i.e, if A9:B9 is empty, then the rows below should move up pushing all the empty cells to the bottom within the Q1.
In Q2 (D4: AE12): All cells except the last column should not have any background color and if any cell is empty in row D8:AE8, the entire column should be deleted.
In Q3 (A25:B75): All cells should not have any background color and if any cell is empty in range A25:A75, the entire row should be deleted.
In Q4 (D25:AE75): The cell with any alphabet should have the color which is given in Q1 for that alphabet. Eg: "A" in Q1 is pink so all cells which have "A" in Q4 should have background color as pink.
Note: The ranges mentioned above varies from document to document.
I have written a code for Q2,Q3 as below but I am getting a run time error.

Please Login or Register  to view this content.

Please help!!!

**StephenR** · 03-05-2014, 12:18 PM

Which line errors?

In your calling macro, you don't pass any range, or at least you haven't defined C.

**roshanvmech** · 03-05-2014, 02:19 PM

Please Login or Register  to view this content.

This one throws an error stating Run Time Error : 1004 Cannot use that command on overlapping selections.
I get the same error even if I directly put the code within the if clause and not by calling subroutines. But if I run the for loops individually it is working.