Subscript out of Range error on recorded macro

**Benatfox** · 06-04-2018, 07:02 PM

I believe the code is looking for specific workbooks and/or sheets and I need this macro to run ambiguously. I get a 'Subscript out of Range' (error 9).

Also, I am sure the code is extremely messy and would also seek direction on how best to clean it all up. The code at the top was entered by me after I recorded the macro in hopes of correcting the issue, which did not resolve it. I am new to VBA so I would appreciate direction on how best to clean it all up.

Any guidance would be greatly appreciated.

I have attached the code in question.

**gmr4evr1** · 06-04-2018, 07:29 PM

Benatfox,
Hi, welcome to the forum. Could you attach a sample workbook with you code and the all the sheets you are using within the workbook? It may be difficult for us to get the same error you are getting without it.

**Benatfox** · 06-04-2018, 07:47 PM

Hi gmr4evr1,

Thank you for the reply! I have attached the entire work book as requested, which also contains the module in question.

I wrote this using the macro recorder and tried to clean it up a bit, but I'm sure it's still a mess.

Basically, I need to run the macro, which will create three additional tabs - all with the same data, just viewed differently. Right now I am getting a subscript out of range error and my assumption is that it's because the macro is referring to specific workbook or worksheets.

Thank you in advance for your help!
Ben