This is part of My Code, so you will "see" the problem:

.......
Sheets(9).Range("b25:g34").Name = "Rng8"
Sheets(10).Range("b25:g34").Name = "Rng9"
Sheets(12).Range("b25:g34").Name = "Rng10"
Sheets(13).Range("b25:g34").Name = "Rng11"

myArray = Array("Rng1", "Rng2", "Rng3", "Rng4", "Rng5", "Rng6", "Rng7",
_
"Rng8", "Rng9", "Rng10", "Rng11")

Sheets("AvgPriceFlower").Select

Range("A38").Select
Range("A38").Consolidate Sources:=myArray, Function:=xlSum,
TopRow:=True, LeftColumn:= _
True, CreateLinks:=Fals

........

If a specific column in each range is empty I need to deleted it from
myArray, so the consolidation will process ranges with values in these
specific column say col. C.

Can you point me to the right direction. Your guidance will be greatly
appreciated