Consolidation Problem

A

Arishy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Improvements 6
Subscript out or Ranger Error 9 - I'm lost here! 1
sumproduct in vba 3
Do loop until, step down row - copy paste - not what it seems. 0
Error91- What looks wrong with this code? - ideas? 2
Object required error - Still perservering with this code - Ideas 6
Consolidation refresh (update) 0
Consolidate ...problem 0

Top