Well, I was successfully able to remove the formatting error, however
still have no idea what was causing it. The macro I have combines data
from all workbooks in a specific folder and creates a new file with
todays date. I decided to remove each workbook, one by one, and run
the macro on the smaller set of workbooks so that I could isolate the
problematic workbook. I was then able to find the workbook that was
somehow causing my error, even pinpoint the problematic worksheet,
however I still could not tell what the formatting error was. I simply
remade the workbook and pasted in the data by cell contents ( I first
tried to copy and paste the range of data, however still received the
formatting error by this method ). This solved my problem, for the
formatting error is no longer popping up. I can assume the formatting
error was somewhere within this range of data, but does anyone have any
solutions for finding out where the error might be specifically??? I'd
like to know a better way to trouble-shoot this if this error ever
shows its ugly head again...