runtime error 1004

All, I have a macro that does some error checking on the user's input, changes the control/shape text and assigned macro, and then save the file to a SharePoint site. The problem arrises when the macro changes the control/shape text; for some people it works without issue (like myself) and for...

Hi all, This is my first post, so bear with me. I am currently populating a whole lot of different/identical data to a worksheet and then using a concatenated string in front of all the different figures I am determining which ones are the same. However I now need to delete the duplicate...

i've built a program in excel part of which uses macros to change the colour of cells when a certian word is typed into the cell: Private Sub Worksheet_Change(ByVal Target As Range) Set MyPlage = Range("d6:m35") For Each Cell In MyPlage If Cell.Value = "On Entry" Then...

Heya, I'm working on some code to highlight the ActiveCell's row and column by using the Worksheet_SelectionChange() sub using conditional formatting, but I've run into some snags when I set any of the font properties for the second conditional format. After lots of trial and error, I seem to...

Hi all, I am using a code available on one of the sites for creating a dynamic user form. but i am not able to proceed at all because of Runtime Error 1004 "Application Defined or Object Defined error". here is the part where i am getting it: Sub MakeUserForm() Dim TempForm As Object...

I've tried to figure this out on my own and I keep getting the same error.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm trying to copy a template sheet I've made and rename it to a date that is displayed in the new sheet. I keep getting...

Hi all, I am new to excel vb and I am using a login and password form that I have downloaded for my workbook. It works perfectly until I click on Enter without any information entered in the user name or password boxes. It then gives me a run time 1004 error which means the instruction on what...

Hi I get runtime error 1004, Activate method of Range Class failed when I run the macro below using a double click from a sheet called "Europe". I have highlighted the code where the error occurs - any ideas anyone? Private Sub Workbook_SheetBeforedoubleclick(ByVal Tgt As Range, Cancel As...

Hi there I have a macro of which there's a part which opens another workbook. However the macro stops and reports "Run-time error '1004' Unable to read file. When I open that workbook manually, however, Excel will read it fine. Any ideas? The path to the workbook is definitely correct.

Hi, I have this working arrayformula in excel (only one sheet in the .xls): {=SUM(IF((C5:C25<3);G5:G25;0))-SUM(IF((C5:C25<3)+IF(ISNUMBER(SEARCH("*flat*";I5:I25;1));1;0)=2;G5:G25;0))} What I want to do now is to execute this array formula using VBA and store the result in cell A1. I tried...

Maybe its late in the day but this one is doing my head in. I have a .txt file Im seeking to import to an Excel worksheet where wierd and wonderful macros will do fascinating things to it. But the actual text import is erroring and my brain has screamed that its after 4pm and then gone to the...

I have a workbook that is supposed to create a new worksheet for each project listed from A7 to A500 in the worksheet named "list," each new worksheet is supposed to have the same layout as the "template" worksheet. The full code is below. It begins updating fine, but then I get a runtime error...