run-time '9'

Hi All, I am new to VBA and I am trying to have one sub open 2 files that are stored in different file paths. The below is my current code: Sub ExceptionReportSCV() ' ' ExceptionReportSCV Macro ' ' Keyboard Shortcut: Ctrl+Shift+T ' Workbooks.Open Filename:=Sheets("Execute").Range("F1")...

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. There are 2 sheets "Cover" and "PP" that must be included anytime a user wants to generate a PDF. Below is my code and I feel as...

I have a list of data that includes contact info for realtors in my area. My desire for the macro was to take this list of data and move the data into a associated column for that data so that I could have a table of data. For example, move the persons name to the name column, phone number to...

Hi all, very new to VB and would appreciate some help! trying to copy a worksheet into 219 different workbooks. I've pilfered the code below from an old post (08) on this site but I'm getting 'Run-time error 9 : Subscript out of range'. Can anyone help please? :) --- Option Explicit Public...

I have a document that is basically a big Table of Contents, with hyperlinks to helpful sites. I have 2 macros- the first is basically a keyword search, that hides all rows that don't include the keyword that the user enters into cell H2. The second is a simple command to unhide all of the...

Hey guys I have had a friend helping me put together this code. Basically I have .txt files I have information on and I need to add that information to an existing database by matching ID numbers however the ID number in the .txt is embedded in the middle of a larger ID number. (i.e. on excel I...

I am attempting to have a user form where the user clicks on a button to Add content into a worksheet. The code is as follows. 'Summary: Button for User to Add DAA. User clicks button and userform1 appears. 'User adds DAA, Career Path, Moves applicable Skills and Strengths to the right listbox...

Hello everyone, I am rather new to programming and especially VBA. As a kind of side-project at work I am attempting to run a macro to pull information from Outlook 2010 into Excel 2010. I have browsed the internet looking for some information and I have been able to pick and pull from other...