hippy
09-05-2008, 09:40 PM
I have code to open all workbooks contained in a folder, copy a named range in the first work sheet of each workbook, and paste to another workbook "WPRCases"; creates a sort of master copy of records.
Code works as expected if the workbooks are not filtered. If Workbooks filterd then only the visible data is copied and pasted.
I have tried several different ways of detecting and turning autofilter off, detection seems to work, though turning autofilters off not worked as hoped. This is observed by a simulation using "Test work books with same fintie data.
Either I have incorrect code, or I do not know enough to get the job done.
Does anyone know how to get around this issue?
Code works as expected if the workbooks are not filtered. If Workbooks filterd then only the visible data is copied and pasted.
I have tried several different ways of detecting and turning autofilter off, detection seems to work, though turning autofilters off not worked as hoped. This is observed by a simulation using "Test work books with same fintie data.
Either I have incorrect code, or I do not know enough to get the job done.
Does anyone know how to get around this issue?