object required error

Hello, I am trying to run a find loop and keep getting an object required error. I cannot determine why I am getting this error. This code ran great previously. Any ideas? Private Sub cmdEdit2_Click() ' Page 1 Dim findvalue As Variant Dim cNum As Integer Dim Staff_DataSH As...

Hi there, I tried reading a few different threads with similar error messages to try to resolve this, but I'm evidently missing something. I should preface this by saying I'm new to macros and VBA (using various examples and tutorials to Frankenstein my way to something functional). What it...

So I am trying to create a macro that reads the value in my Worksheets('Main Page").Range("B13") and then goes and searches through the rest of my sheets and will delete that entire row, in which the value is found. I am receiving an error that says "Object Required". Any help would be great...

Hello, I have an array that can have a different number of columns and rows. Sometimes there can be *'s as the values. I am trying to eliminate them, but first I need to be able to count the number of *'s in each column. I have to step through each column at a time because of other steps I do...

Hi, I've been searching all day for answers to how I can pull this off. I have two tables of data where records match up when the tables are placed side by side. I have a code that currently highlights the entire row of the sheet for which cell I have active. Works great. But I also want to have...

Hi, I am trying to write a macro which highlights the second, and all following duplicates, in a table using ListObjects Unfortunately, it keeps returning an 'Object Required' error when arriving at the "countif" function. In the debug mode, the variable "Dupl_Cell" has a value when I hover...

Hi I'm trying to make a chart and i use this code ActiveChart.SetSourceData Source:=Range(nom_projet_liaison_achat!K3, ActiveCell.Offset(0, 1)) Excel tells me : error 424 object required, i don't get why because the gaph did appear ...

When i run it i get object required. I only have on line of code: Public Sub VisGæstForbrug() frmGæstForbrug.Show End Sub

Hello, I've got a problem with some cascading list boxes and a single drop down. There are 4 list boxes and 1 drop down and a user selects options from each of them to make a configuration. They are embedded in the worksheet "Instructions" (not a Userform). I encounter an object required error...

Hello, I am getting the "object required" error when I try to perform a for each command. Basically, I want, for each string text in a defined array, create a new spreadsheet. However, I got stuck at the for each command. Any help would be appreciated. The code is as follows: Dim rng As Range...

Hi all, I'm currently making an excel workbook where a user inputs a range of data which gets processed and reorganised into a table like the one below found in the "Intermediate" sheet in the workbook. There can be anything from 1 series to dozens, even hundreds. <tbody> Name Y1 Y2 X1 X2...

This execution error is one of the strangest ones I've seen in Excel VBA, though admittedly I haven't seen that many. The "Object required" error occurs at the "Set datecell.Value2 = weekdays(wkdy)" statement. (in red font below) I've tried several different ways of defining and declaring...

I dont totally grasp the whole declaring variable part yet but I am getting an object required error on "NewLoc" in my code. I realize this is probably pretty basic but I can figure it out. Dim myLoc As String, myRng As Range, NewLoc As String myLoc = InputBox("Enter what you would like to...

Hell o, I'm getting this object required error, which I do not know what it means exactly. The code I'm running is shown below: Dim TestYear As Long, TestMonth As Long, TestDay As Long, TestDate As Date TestDay = Day(TestDate) TestMonth = Month(TestDate) TestYear = Year(TestDate)...

Excel 2003. I believe I've got everything working in the code up until: If rnGx = rnGy Then It loops once and then "Run-time error '424': Object Required" for the code above. Sub test1() Dim rnGx As Range Dim rnGy As Range Dim i As Long Dim xNum As Integer Dim yNum As...

I need to copy from anohter workbook on my I:/ drive and paste into "Sheet 1". I have the cde below but get an "Object Required Error. Please help?? Thanks in advance :) Sub Macro2() 'Assign variable name to Target workbook Var1 = "ActiveWorkbook.Name" 'Assign variable name...

Hello,I am working in excel/access 2003. I have a macro running out of access in which I create an excel workbook (a copy of an existing template) and try to paste the results of several access queries into this workbook. I first try to check if a copy already exists or not. If it does I delete...

Hi all, i have some difficulty in understanding the purpose of both types of variables in excel macro. Furthermore, i have a problem in my codes right now, Dim TotalRow As Integer Set TotalRow = ActiveSheet.Rows.Count ActiveCell.Copy For i = 1 To TotalRow...