run-time

Dear all, I am trying to run a macro that sends out emails, however when I try to run it I keep getting this error unfortunately: Can somebody please help me figure out why? I have tried setting source = ThisWorkbook.FullName (takes the current excel file I am typing in as an attachment)...

I am totally confused here. I was well into a project and assigned a value of 14464 * 5 to a variable and got the run-time error 6 - Overflow. Hmm, oh yes, I dimensioned my variable as an Integer. No problems. Changed to a Long. Saved, re-ran the code. Error 6 again, overflow. Sorry, but this is...

Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...

Hello Experts: I have a rather irritating problem that does not make sense to me and I am hoping that someone can help please. I have some code that: Creates a list of files to be opened Opens each file in the list and scrapes some specific data from each file opened if present Places the...

I have a monthly report which has a macro that combines data from two sources automatically and updates several pivot tables. This report used to work flawless on ex coworkers computer. He sent me the report and now I cannot make it work. I receive below error: Run-time error '1004' : We...

Hi, I'm trying to run the following macros from a userform but continues to get an error each time I try: Private Sub CommandButton1_click() Call Worksheets("Sheet1").CommandButton11_click Call Worksheets("Sheet1").CommandButton12_click Call Worksheets("Sheet1").CommandButton13_click Call...

Afternoon all!! I have a baseball spreadsheet that has been working up until a couple of days ago. Something weird started happening when the 3rd out happens and it goes to the sub "currinning". I get a Run-time 13 error everytime the Call to currinning happens. No matter what type of out...

Hi all, I'm attempting to write a macro that puts data into a pivottable automatically. This seems pretty simple, but I can't quite figure it out. I think there is a problem with the name of the table and location its going to? I'm not to sure. I'm getting the Run-time error '1004'...

I am trying to Sync a file to my Excel workbook and getting this error message. I am still very much a novice and have a lot to learn. Not really sure how to go about fixing it. Can anyone please explain and help with this problem...

For the life of my I cannot figure out why the following line of code is giving me a "Run-time error '9': Subscript out of range" Error. Workbooks("Lookup").Worksheets("Sheet1").Range("A1:BK2000").Copy Destination:=Workbooks("EstimateChecker").Worksheets("estsheet").Range("A1:BK2000") I am...

I have created this macro and it works fine on my computer. However, I sent it to coworkers to use on their computers and it does not work. Private Sub Workbook_Open() ' ' MoveDateBoxMain Macro ' ' Sheets("Main").Activate ActiveSheet.Shapes.Range(Array("DTPicker2")).Select...

Getting this run-time error 1004 and when go debug highlight the the following line of code: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=OpenPDFAfterCreating...

Hi, I have a macro that build PowerPoint presentation from excel. And workbook that has several tabs and their names as below: "It would take", "Themes_2", "Themes_1". When I tried to build the slides this is what happened: "It would take" tab successfully built into .pptx but the rest of the...

I have a problem with an exel file. I work in a company and we use a file to analyze employee performance. When I open the file and enter the parameters of the day and time to see the productivity, exel reworks the file (connecting to an internet page of the company system) returning me the...

Hi, I cannot for the life of me figure out what I need to do to stop this from happening. I am working to edit some VBA that a colleague has created. There is a simple error in a line where the current text is .row 1 This needs to be +1, but everytime I type +1, it autocorrects it to the...

Hey guys I have a macro that has always worked. Now suddenly it will not load in my XLStart folder when opening a document and when I try to go into the macro it states: Run-time error 50290: Method 'LinkSources' of object '_Workbook' failed Does anyone know how I go about fixing this?

Hi one & all, I have used this site many a time and it has helped me a lot, but this is my first post so if I have posted it incorrectly, I'm sorry. I am also aware that there is probably a smarter way to do this code, but as I'm self taught it usually a matter of trial and error for me and I'm...

Hi, I am trying to rename my worksheets (540 of them) based on the value in cell A200 (which is a formula pulling together 3 cells, so =A1&" "&B1&" "&A3 ). I've checked all the sheets to make sure there is a value in cell A200. However, when I run the below macro, I get a Run-time error...

I am getting a "Run-time error '9': Subscript out of range" on the following code: Worksheets("Exhibit ""I""").Activate The worksheet name is Exhibit "I". If I remember correctly about what that run-time error means, on this line of code its saying it can't find a sheet with that name to...

Hi everyone, can anyone please help me to correct this Run-Time '13' error? The error message popped up at the highlighted line of code. Here is the code With ActiveSheet.PivotTables("xLabor").CubeFields("[CSVFolderPivotTable].[FAIN]") .Orientation = xlRowField...