data consolidate vba

[Scott R]

I haven't been able to find any reference to controlling the actions in the Consolidate dialog box. I know the basic Range.Consolidate Sources:=
But what about the other actions in that dialog box such as adding/deleting range references?

 

[JLGWhiz]

I haven't been able to find any reference to controlling the actions in the Consolidate dialog box. I know the basic Range.Consolidate Sources:=
But what about the other actions in that dialog box such as adding/deleting range references?

If you hover the mouse pointer over the 'Consolidate' button, a dialog balloon will appear and at the bottom you will see 'Tell me more'. Slide the mouse pointer to the 'Tell me more' and click on it. It gives detailed instructions of how to use the 'Consolidate' feature. But it may not be what you expect it to be.

 

[Scott R]

All I've learned so far is that source names are stored in Worksheet.ConsolidatingSources and are indexed, i.e. Sheet4.ConsolidatingSources(1) = string representing the file/rangename source location.

I'm interested in deleting this source with code but don't see that it's possible.

 

[JLGWhiz]

All I've learned so far is that source names are stored in Worksheet.ConsolidatingSources and are indexed, i.e. Sheet4.ConsolidatingSources(1) = string representing the file/rangename source location.

I'm interested in deleting this source with code but don't see that it's possible.

Sorry, I misinterpreted your original post. Do you want to delete the range array of cells from which the consolidation is formed? If you would post the code which you are working with, perhaps we could offer a solution.