object required

I am having trouble with the following code where I get a Compile Error: Object required error on the first set command. I'm obviously missing something right in front of me, but I can't spot it. Why doesn't it like hHeader? Thanks for looking at this. [code] Sub delHead() Dim sh As...

Hey, I have designed a button to run a macro which deletes old information when pressed. I wanted to have a vbYesNo MsgBox popup to ask the user if the are sure they wish to delete data. This macro seems to work fine and completes its task but once it is finished I am getting "Object...

Hello Everyone, I have 2 Activex ComboBoxes on a sheet and I am trying to populate the range in the 2nd combobox based on the value in the first combobox. Here is my code. But whenever I run it, I get the following error: "Runtime error 424, Object required" .. Please Help! Note: Linked...

Hi, these procedures belong to a rather long process, so I've pulled out only what I think is applicable. The first two procedures work fine. The second two procedures should work in the same way, only they don't. Instead, I receive a 424 on line 1 of Sub TransferAssociate(MyCell). So far...

Sub chk() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("Query3", dbOpenDynaset) If rs.RecordCount = 0 Or rs.Fields(Format("maxof_EndDateTime", YYYYMMDD").Value) <> Format(Now(), "YYYYMMDD") Then '03/12/09 add the new check if date is not equal to today's date 'Not completed yet...

I'm trying to run a somewhat generic VBA code from one of Mr. Jelen's books (VBA and Macros for MS Office Excel 2007). I'm trying to extract a unique list of values. [Besides using the "Remove Duplicates" function]. I have my dataset in Book1, Sheet1, beginning in cell A1. Here is the...