Hi,
I have a process that currently run weekly which pulls data from 12 individual workbooks into one master workbook for an executive view.
Each user of the individual workbooks has the ability to create a list range in their workbook to add new data using the
method and an offset named range. This is done to extend data validation fields and formulas to new cells as data is added. I have this set up using a simple macro to start it and a macro to convert it back to a range again.
Problem is that users forget to run the second macro and worksheet stays in list mode making the consolidation process error out when it hits a workbook with this condition.
I am looking for a way to check each workbook when the consolidation macro runs to see if the list mode is still engaged and if so run the convert to range macro. I am unsure if this is possible and what the VBA code would look like for it.
Any help is appreciated, if you need further clarification please let me know
I have a process that currently run weekly which pulls data from 12 individual workbooks into one master workbook for an executive view.
Each user of the individual workbooks has the ability to create a list range in their workbook to add new data using the
Code:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("list_range"), , xlYes).Name = _
"List1"
Problem is that users forget to run the second macro and worksheet stays in list mode making the consolidation process error out when it hits a workbook with this condition.
I am looking for a way to check each workbook when the consolidation macro runs to see if the list mode is still engaged and if so run the convert to range macro. I am unsure if this is possible and what the VBA code would look like for it.
Any help is appreciated, if you need further clarification please let me know