hi,

i have cobbled together this code. it works how i want but it runs slow (no surprise really; it's a right patchwork of coding i wrote, found or recorded).

it:
deletes all old data in the workbook
opens up every excel file in a directory in turn
looks for a worksheet called "summary"
copies it to the workbook
then:
runs through each sheet in the workbook
removes the protection
strips it of all formatting, removes any objects, removes the autofilter
copies the contents of columns A to E into the 'master' worksheet
then:
clears any blank rows in the master worksheet
clears row that contain "PEOI" in column A (except row 1)
does some formatting
then:
deletes all other sheets
time stamps it

but inefficiently

would anyone like to browse through the code please?

Please Login or Register  to view this content.