run-time error

Hi, i keep getting the above error when trying to run this last bit of my code: Dim laddercount As Double Dim x, y As Double laddercount = Evaluate("COUNTA(R:R)-1") For y = 19 To laddercount + 19 For x = 7 To x + laddercount Cells(x, y).Select...

Hi all, I would like to use a macro script to import a (TAB separated) CSV file which was exported from a database. It seems to work - I can see that rows are being imported (although the first cell contains two additional weird characters: ÿþCampaign Name). However the script stops at "Line...

Hi! I made a userform via ActiveX Controls on my sheet, and I have a list box that uses Vlookup to fill in two other text boxes on my userform. Therefore, when the user clicks the part number from the listbox, the Part description ( TextBox1 ) and Std. Hours (TextBox2) for the part is filled...

I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...

Here is the code I found and slightly altered. It gets a run-time error on the bolded line below. It worked prior to me trying to convert but now I need to make it compatible with other versions of Outlook. Please advise. Sub CreateTask() Dim OLApp As Object Dim olName As Object Dim olFolder...

I am receiving the following error message when trying to pull names from column A into individual worksheets, Run-time error '1004': Application-defined or obeject-dfined error. Here is part of the code [code]:Range("A1").Select Selection.AutoFilter...

Hello All, The code below yields run-time error 1004 on the lines for AH15 and AH44, but works fine for AH19 and AH48. The only change to the formulas in AH15 and AH44 was "-R[-5]C[-20]-R[-5]C[-19]-R[-5]C[-11]" replaced "-R[-5]C[-21]-R[-5]C[-12]". The macro uses an input box for the week number...

Sub CnvToHyper() ' ' Macro1 Macro that converts a display to Hyperlink enable so that ' Mouse on Hover works. ' Dim display As String Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Sheets("TestHover").Activate With ActiveSheet For i = 1 To 0 Step -1...

Hola, I've got a pretty long macro that throws a Run-Time Error when ran, but does not error out when I debug and step in the code. I've got lots of cell value evaluations and its probably a Null value causing it, but I need a way to confirm. I'm about to create a log worksheet and just write...

I'm getting an error message when running my macro. I'm just trying to open files and paste values part of a sheet into my sheet with the macro. About halfway through running it is when I get my error. The error is showing up on the line with red text. Thank you for your help. Dim Dept Dim I As...

I am running code on thousands of lines of data with a loop. The code runs smoothly for a long time then will debug on the public function below. It goes through this paste function many times and just quits working randomly. I am coping data from a Reflections session then finding the cell in...

Hello, I am trying to create a macro that will allow me to change the source file everytime I want to view a specific account. I scoured the web to find out how to do this and here is the code I've written Option Explicit Sub EditLink() Dim OldLink As String Dim NewLink As...

I can't figure out how to get rid of the Run-time error '1004': My VBA code is supposed to write a simple ISERROR-function to the worksheet. When I type it manually and record a macro the code reads:ActiveCell.FormulaR1C1 = _...

Hi, I have an Excel tool that is currently working on over 300 user's machines but is failing on 2 specific peoples. The code in question, creates a new Excel workbook, then copies over a worksheet and then emails it. Both of the users having problems have Excel 2007. Does anyone have any idea...

Hello All! So I'm running this code to extract multiple charts (2) from each worksheet in a workbook and then paste each chart to a seperate powerpoint slide. When the code is run, I get the following error: Line of Code: Set PPTShape = PPSlide.Shapes.PasteSpecial(link:=True) And the...

Hi guys, I have made an Excel file in 2007 which sends data to a Word file via mail merge and everything works fine. This is the code: Sub JobCardMerge() ' ' JobCardMerge Macro 'Open Word and run the mail merge MsgBox "When prompted, please select the sheet called 'Merge$'" & vbCrLf &...

I have two identical userforms. I want to give them different names. If the word Google appears in the UserForm, I want to swap it with Yahoo. I figured this would work: Sub Test() Dim Ctl As Control Application.EnableEvents = False For Each Ctl In Google.Controls...

Hi, I have a macro which run perfectly from Excel but the file has to be posted on our company intranet which uses redirection so the file opens up inside Internet Explorer. I can't change user access to modify the settings to open an .xls file only in Excel either! When the macro tries to...

Hi, I am not a genius on VBA and I have only recently started teaching myself a thing or two about it. Basically what I needed to do was apply more than 3 conditional formats to a range of cells. I have drop down cells that represent the "Status" for Projects that I am working on.. I have 5...