error '9'

Dear Excel Forum, The is the line of code I am using to copy the tab "PE Master" to the workbook I am currently in. Workbooks("Profit Template.xlsm").Worksheets("PE Master").Range("A1:K200").Copy Destination:=Range("A1") When I run the code, Excel opens a window and is looking for me to...

Hello All, I am trying to select sheets to generate a PDF by using a UserForm with checkboxes so the user can select which sheets he/she wants generated into a PDF. Below is my code and I feel as if I am close but I continue to get a "Run-time error '9': Subscript out of range" at the...

I am not very knowledgeable in coding. Just a marketing student trying to do some research. I borrowed this code from the internet to collect data on movies. When I run the function, it shows me error 9 - subscript out of range (in bold - year = parts1(2)). I tried looking for answers and...

Hi Excel VBA Gurus! H.E.L.P. P.L.E.A.S.E Am new here and hope someone can help, I am literally pulling my hair out. :confused: I have searched and searched and not come up with a solution and cannot explain what is happening. Basically I have a worksheet in Excel 2013 (on a Win 7 X86...

Hi guys! So I'm new to creating macros with VBA and am trying to create one (just finished recording and started debugging) that basically encompasses creating a pivot table from a data set, sorting it in the pivot table, running some calculations on the data, and then graphing the results. The...

I have the below code that I am trying to run. I am compiling data for all employees on my team for 2010. Some people didn't join the team until part way through the year and some people left before the year was over. What I want my code to do is look through the open workbooks, find the first...

This relates to a project which uses multiple sheets, named SL 1, SL 2, ..., SL 99, SL 100, etc. This is a contiguous sequence. A section of code is supposed to scan through all the sheets to identify the final sheet, whereupon other actions will occur. This fails with "Run Time Error '9'" on...