error 424

I'm sure this is something super simple, but I can't figure it out. Dim addMe As Range Dim dashB As Worksheet Set dashB = Sheet1 Set addMe = dashB.Cells(dashB.Rows.Count, "A").End(xlUp).Offset(1).Row setting the addMe is giving the error.

Hello. I am trying to run a code that after reading the value of cell "A:2" must display a picture in the active worksheet. This is my code: Public Sub insertpicture() If Intersect(Target, Range("A2")) Is Nothing Then Exit Sub End If Dim myPict As Picture With Range("A20:J20") 'Set myPict =...

Sub SaveInvWithNewName() Dim NewFN As Variant ' Copy Invoice to a new workbook ActiveSheet.Copy NewFN = "C:\Users\Donny\Google Drive\Data\Invoice" & Range("B15").Value & “.xlsx” ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook ActiveWorkbook.Close...

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...

This is the First Macro i've ever tried to create. There is two but they are both giving the same error. Any help is appreciated!!! Sub L2LTrue() If L2LCheckBox.Value = True Then 'L2L True Macro Range("E20").Select ActiveCell.FormulaR1C1 = "=R[38]C[5]-R[39]C[1]-R[-12]C[-3]"...

Hi, I am trying to write a code which will loop through all excel workbooks in a particular folder & copy data from a specific tab on each sheet and then paste it to a master excel workbook. I have got the code to select folder, extension, tabname basis inputs from user and also loop thru...

Please forgive the rudimentary nature of the question, I have not written in VBS/VBA in a long time and I have never used it with Excel. I find myself in need of a loop to help me write a configuration for a Cisco router. I see to be a simple enough endeavor, but whenever I run the macro in...

I am having issues with this code calling the public function EditEntry on frmRunEntry Private Sub CommandButton1_Click() Dim Response As Long Dim RowNum As Variant 'Get the record ID from the user Response = InputBox("Please enter the ID number") 'Test the user input...

I'm trying to run a .find operation in VBA but keep getting Run-Time Error 424 = Object Required. What does that mean? Below is my code. If you can help me identify my error i'd appreciate it. Thanks, Note I've declared 'WorkOrder' as a Double type (it's a work order number with two digits...