error 424:object required

I am attempting to simplify some VBA code as it has gotten fairly long and is taking an extensive amount of time to run. I have multiple cubes that are updated weekly and I need to copy data from those cubes to a new sheet where I can manipulate and make edits. Rather than having three subs with...

Hello I just need to do a basic thing. When I press button I want to get the location of button for example to mgsbox. My code is here: Sub GetLocation() Dim Row As Long Dim Column As Long Row = Application.Caller.Row Column = Application.Caller.Column MsgBox...

Hi, This is my first try. I am developing mini project in Excel VBA. I have get some errors (object required) while calling function.. Kindly solve this problem. Sub recentrecord() Dim lastrow, i As Long 'Dim ws As Worksheet Call Activate_Cluster lastrow =...

Hi, I have this code and I got "Error 424 Object Required". Any idea on the cause? Here's the code: Sub AC_idle() Dim Res As Variant If Target.CountLarge > 1 Then Exit Sub If Not Intersect(Target, Range("N18, Q15:Q28")) Is Nothing Then Res = Evaluate("INDEX(N18,MATCH(" &...

Hello All, First time posting so bear with. I have a spreadsheet (Global Template) with a pivot table referencing data from another file (not open and a year to date file information). I want my macro to show the detail of the grand total on a new sheet, I have the code in place for this...

So, this code isn't working for me. For whatever reason, I get an " Error 424 - object required" error, when I try to pass the object into the sub. I do not get this error when I try to use it outside of the function. Private Sub Form_Load() Dim obj As ListBox Set obj = Me.ListNiveau...

While running the below code, I am getting "Run time error 424 - Object required" on line no (6). Please help me to sort out. Thanks 1) Sub test () 2) Dim ws as Worksheet, Sr as Range, c as Range 3) Set ws = Activesheet 4) With ws 5) Set Sr = Range(.cells(2,2), .cells(10,2)) 6) For...

Hey, I am currently working on a macro for duplicating a worksheet and pasting specific values from it into a new column of a remaining worksheet. However, whenever I try to paste link specific values to another worksheet, I receive the message 'Run-time error '424': Object required'. This is...

Hello, I have an Excel workbook with two different user forms. I want to use an Initialize event to populate some combo boxes. On the first user form, everything works great. When I try to use the second one, I get "Run-Time Error 424 Object Required". The debugger highlights the line in the...

I finally got my code to compile, but can't run it due to an 'Object Required' Error. Runtime 424 Error from the worksheet button. I think it's because I need to us a SET statement when assigning a value to an object, but since I'm not using an array I'm not sure where it needs it! code below...

Hello! I'm trying to make a range selection in a pivot table as per the snapshot below: http://imageshack.us/a/img27/4411/ixaj.jpg The values I am trying to select are the ones that are both red and italic. (Mobile, Other Fix, Fix) from CBU_NA. I've searched and found a way to select both the...

Hey guys, I'm having some trouble with an input box command. I'm creating a program that transfers data from one worksheet to another (within the same workbook) and the data is sorted by column under their respective column headings. For example, the first worksheet may contain a column labeled...

I am pretty much a newb re macros. I have a client who has asked me to troubleshoot a macro that was working for a long time. the PC crashed and now the macro does not. I helped them resolve some reference issues when they reloaded the OS. However, they now have a runtime error 424 object...

I get 'Error 424: Object required', and I can´t figure out why. I have a listbox named ListBoxforPrint in the Worksheet (not a userform). SmainMenu is the CodeName of the sheet. Can you please help? Tx