Hi,
I'm sure this problem is super easy for you guys. I haven't been able to get it to exactly work (I'm trying to learn VBA). I searched but didn't find what I was looking for which isn't usually the case. So my problem is I have a workbook with a number of named sheets with data dumped into them from another macro that matches files to the sheet names.
I want to now run through all sheets except the first one (lets say it's named "Master") and format the data in each one into a table style. I can't have it format all data found because there is header information in each sheet and I have the data start at A4 across all sheets (this is a template workbook so the length of data on each sheet can change each time this process is run but it will always start at A4).
Here is the code I have that isn't exactly working right:
Thanks for any and all help!Please Login or Register to view this content.
Bookmarks