runtime error 1004

I'm not sure what I'm doing wrong. I've tried multiple things and looked at different threads, but i still get the Run-time Error '1004'. I'm just trying to do text to column for range A:A in Sheet "LY". This is the code I've been using Sheets("LY").Select Selection.TextToColumns...

Hello, I'm working with an excel worksheet with macros and there are several Combo Boxes (Form Control) on one worksheet. Most of these Combo Boxes have only 2 items to choose from so I thought it would be nicer to have List Boxes to replace them. I started by trying to replace just one combo...

Good Day, I am very new to vba and am trying to make this work. I have a workbook with more than 20 sheets. Each one of them has a pivot table with a source in an external workbook and each one of them has an outline that allows group/ungroup a set of rows. I need all the pivot tables to be...

Hello, I've created a calendar with macros, however when I try to protect the sheet I get a runtime error. I'm learning macros and have tried various codes but have not helped. Here is the macro I have: Sub HideMonths() Application.ScreenUpdating = False Dim rngDates As Range, rngMonths As...

Hi all of a sudden i am getting this error "runtime error '1004 'Range of object _Global failed". earlier this used be working fine, dont know what happend as i am new to VBA. when i debug this i am getting this error at the following code Range(rcout & outcolml & 1) = Range("'heads'!" &...

Hi all, As a newbie to macros I am having trouble trying to save a worksheet to CSV file. The macro worked to .txt but when I change it to .xlCSV it comes up with runtime 1004 error, method 'save as' of object '_workbook' failed. Any help would be amazing. Cheers Sub Export7400_setup_Click()...

First off, sorry to ask about runtime error 1004, but I am not that familiar with VBA and I cannot find a solution anywhere that I can make sense of. The problem I get is: Run-Time error '1004' : Application-defined or object-defined error Here is my code: Sub DateInsertion() ' '...

Hello all, I am currently working on a code, which is used to visualize graphs. I copy paste the data from other work books and create the graph. It works fine in the debugging mode, however I come across run time error when I run the macro. Call createchart1(j, k, j + i1 - 1)...

Hello, Currently I am trying to use Elseif statments to copy and paste information into a target cell from another cell on the same worksheet based on the value of the target cell. When I try to run my code, I recieve the following error message: 'Run-time error 1004: Application-based or...

Hello! I've spent a while now looking online for a solution to my problem, but I'm still getting the same error. I have a range in a worksheet (LAYOUT) that I want sorted first by column B ascending then by column C ascending. I do NOT want to select or activate the worksheet, if that is...

Hi Hope you can help with this <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> problem! I included a code...

Had some problems with a computer so I had to completely reinstall Windows XP and subsequently Microsoft Office 2003. I have an Excel document that had no changes between the time I reinstalled Windows XP and Excel and opened up the Excel document to test the new Office install. In this Excel...

The following code worked several times and is now giving a Runtime Error and tagging the dst.value = frm value portion Sub UpdateWeekly() Application.ScreenUpdating = False Dim i, ofst As Integer Dim frm, dst As Range Set frm = Sheets("Weekly").Range("K5:BDI6") Set dst = frm.Offset(2, 0)...

Hi All, Hoping someone can point me in the right direction with some code i am writing. Background: I currently have 8 workbooks saved in a given location. Each workbook is in the same format and has a worksheet called "Stock" I have written code that loops through the file and opens each...

Hello, Im trying to make something that will manipulate data consistently across multiple workbooks. I am having trouble with the 255 character limit of the FormulaArray function (I tried the .replace workaround and I'm not sure if I did it correctly) and when I'm not getting that error I'm...

I know nothing about Visual Basic,so bear with me. I keep getting this error when I try to close Excel & I have no idea why or how to isolate the issue. This happens on any workbook. I want to say that I have tried to repair Excel, but that didn't fix the issue. Please help!!!!

Hi all, I have a macro which I want to search through a list of dates in a range, and for each date found where the given criteria is met, paste the column header into another sheet in the same workbook. Here is my code... <code> Sub compile() Application.ScreenUpdating = False...

Hi people, I'm pretty new to vba and keep getting a run time error 1004 on the highlighted line when i run the following macro... <code> Sub auto_open() Dim cwb As Workbook Dim arow As Long Dim brow As Long Application.ScreenUpdating = False Set cwb = ThisWorkbook Sheets("Domestic...

Running Excel 2010 Here is my code: 'Select the correct Range to copy and copy into the sheet Set FromRange = Workbooks(Info.FromBook).Worksheets(TEMPLATESHEET).Range(NumHeads) Set ToRange = Workbooks(Info.ToBook).Worksheets(Info.ToSheet).Range("A" & RowTo) 'Copy the template...

Hi, I've searched the forum and not found any posts reporting this problem. When running a QueryTable command in VBA I keep getting the error: RunTime Error 1004: Invalid object name: 'MyDatabase.Data.Amount_Source' What I cannot understand is that when I copy the SQL Query Command Text...