I am trying to name a dynamic range. The below works when I have selected the relevant sheet. However, if the sheet is not selected then I get a Runtime Error 1004 at the Else line. I had planned on naming 3 ranges like this on each sheet. I have 15 sheets, so end result will be 45 ranges.
Sub CIT_SLA()
'Name and size the range CIT_SLA so the Word file (EOM Report) can pick only the relevant cells
If Sheets("CIT Results").Range("A2").Value = "" Then
Sheets("CIT Results").Range("A2:G2").Name = "CIT_SLA"
Else: Sheets("CIT Results").Range("A2", Range("G65536").End(xlUp)).Name = "CIT_SLA"
End If
I am having difficulty getting a form to work the way that I would like it to work. I have a form that is used to display questions that my students will be answering. The form also is used to put the answers into a worksheet. I have 2 sheets. Sheet2 has the questions, student answers, and correct answers. Sheet1 is used to indicate correct answers and to keep track of percentage correct. I am fairly new to VB. I have 2 pieces of code that I am going to post. The first one works and the second one doesn't.
This is in the "This Workbook" section and it works. Option Explicit Public intNoQ As Integer Public strNoQ As String Public NumberofQuestions As Integer Dim StudentName As String Dim InputBoxAnswer As String Public Sub Workbook_Open() Application.Visible = False 'Hide Excel Load Questions Load NumberCorrect NumberofQuestions = Worksheets("Sheet1").Range("K3").Value For intNoQ = 1 To NumberofQuestions strNoQ = VBA.CStr(intNoQ) If intNoQ = 1 Then Questions.Controls("QuestionNumberBox").Value = "Question#" & strNoQ Questions.Controls("QuestionBox").Value = Worksheets("Sheet2").Range("B1").Value End If Questions.Controls("CorrectBox" & strNoQ).Visible = True Questions.Controls("CorrectLabel" & strNoQ).Visible = True Next intNoQ...............
I have a relatively complex report that I work with and a worksheet is no longer required. I have deleted the worksheet and reference to it hwoever when running the macro to pull all the data, it gets to the summary of all the data and i get the Run Time Error 1004 Application-defined or object-defined error pop up. ON reviewing it, it is on this line ActiveCell.Offset(0, 0).Range("a1:a" & Range_Height).Select of the below code...
VB: Sub GetRangeName() Sheets("TOTAL").Select
[Code].....
use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window.
I have a simple function below to put in different forumlas in different cells to get stock quotes. When I run this I get runtime error 1004 application-defined or object-defined error. The first formula goes through but vba chokes on the next formula: ActiveCell.Offset(I - 1, 4).Formula = username
I am trying to copy the info from one workbook to another workbook.
I keep getting the above referenced error...
Private Sub CommandButton1_Click() Dim filepath As String filepath = Range("A100") MsgBox ("File Appended") Workbooks.Open (filepath) Windows("CorrespondenceMaster.xls").Activate Sheets("Sheet2").Select Range("DesNo", "LocationPath").Select Selection.Copy Windows(filepath).Activate Range("A2").Select ActiveSheet.Paste End Sub
I have a userform setup to enter data into a worksheet Whee the user hits the button to add the data, I get the error 1004 Application defined or Object defined error It is on the line Set LastRow
Private Sub CommandButton1_Click() Dim LastRow As Object
Set LastRow = Sheet1.Range("a65536").End(x1Up)
....end sub
Now I am sure this has always worked in the past, so Is it me or am I really missing a plank or two?
the first time font.bold is set to true, it completes w/o error. The bolded line returns 'application defined or object defined error 1004'. Ive tried activating the new sheet immediately before setting bold (like the first time it gets set) but it still errors.
I have problems with setting Validation input title and message. When in column "C" I type product code, data validation of corresponding cell in column "D" changes to list of diameters allowed for that product. That works fine. But i also want to set validation message to show allowed diameters.I set it in VBA using named ranges. But for every second line (13, 15, etc on attached file) I get an application-defined or object-defined error. The rest (14, 16 etc) works ok.
I have a very strange problem in DEBUG mode, because i get this error "Application-defined or object-defined error" when referring to a cell and assigning it a value so it goes to my error handler and i have a Resume Next there. It continues to go through the code whilst continuing to go to the error handler but when i step out of the function it restarts again from the beginning on the called function and then on the second run of my code it seems to WORK!?! So i'm thinking what the hell is going on, it falls over and fails the first time round and works the second time round? In free-run mode from excel i just get a #VALUE!
I am having some trouble with a variable range selection within a regression. I keep getting an "application-defined or object-defined error." I've isolated each statement to find that the code that is causing the regression not to work is below (the error for that line of code states that the Select method of Range class failed):
I'm trying to enter a series of formulas into a worksheet using vba. However, this code is giving me Run time error '1004', along with the description in the title. This is the first formula (they're all relatively similar).
I'm trying to figure out why I can run a bit of code on my machine but on another machine I get an: Application-defined or object-defined error. The code is in an excel file on a network drive and it pulls up a form, once the form is submitted it runs some code that looks like so
When opening a blank excel workbook I receive the error "1004 Application-defined or object-defined error". I press OK. And the message appears 2 more times before I am able to work in Excel. Doesn't matter what excel file I am opening, does the same thing. I do not know how to lookup programming code for any macros I am running. I would like to get rid of this error! It is a nusance.
I get "Application-defined or Object-defined error" , run-time error 1004.
Option Explicit Sub Initialize() Dim rList As String Dim CountRows, CurrCol As Integer rList = "myTemplate" Range("A2").Select CountRows = Range(Selection, Selection.End(xlDown)).Rows.Count
CurrCol = 7 With Range("G : G" & CountRows + 1) With .Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=" & rList .ErrorTitle = "JC Message" .InputMessage = "Select requested template" .ErrorMessage = "You must enter a template from a list only" .IgnoreBlank = False End With End With End Sub
when I run the macro, I receive an error: "Run-Time Error '1004': Application-Defined or Object-Defined Error" See attached macro. If I click "Debug", the line "With r.Resize(,1)....... becomes highlighted in yellow.
In one worksheet i have created the following code, which adds date to specific column when data is entered in colum A.
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 1 Then Target.Offset(0, 10).Value = Now() End If End Sub
The problem is that when trying to delete a whole row, error message pops-up. Run-time error '1004' Application-defined or object -defined error. When click "End" actually everthing is ok, the row has been deleted, but was just wondering what is causing that error.
This error is telling me "application defined or object defined error" and i am unsure how to fix it. Basically i have a ton of files within a folder that i am trying to do some reformatting to. I would like to save the new files to a new folder and keep the originals where they are.
