424

This is weird: I have 4 command buttons (CommandButton1 thru CommandButton4) and 1 text box (TextBox1). I get a 424 Error whenever I try to set a TextBox1 property such as TextBox1.Left I ran a short sub to grab all the shape names in the active worksheet: For Each Sh In ActiveSheet.Shapes...

Hi, New to VBA here, getting error 424 object not found with this code after running, it runs only once perfectly but stops after 1 iteration. Consider "yyy" as all different variables (code I am using is below). Any help would be appreciated :) :) <tbody> Sub DeleteSpecifcColumn() Set...

Hi all, I'm new here, so forgive me if any formatting isn't right the first time! I hope you guys can help me out with the following issue: I'm trying to find all pivottables in a workbook using the following code. The goal is to instruct the found pivottables further on, but first I need to...

I have a very basic code to copy "non-blank" data from one sheet and paste to another. The code is not complete yet - I am running in debug mode I get the above error. My code is as below. Sub SampleFind() Dim StrWord As String Dim Quantity As String Dim i As Long Call nrows For j = 2 To 2...

Hey guys, I'm having an issue with my InputBox command, I have underlined the part that's returning the error. .... SelectHeading: On Error Resume Next 'Need to let the user select the proper heading. Dim rng As Range Set rng = Nothing Set rng =...

Okay so its the vfirst time ive tried using developer tools but its been to no avail. I created a calender using the following code Private Sub Calendar1_Click() ActiveCell.Value = Calender1.Value Unload Me End Sub Private Sub cmdClose_Click() Unload Me End Sub Private Sub...