brng

I have a list of 324 sets of data in columns that are identical in size I tried using Record Macro then changing a few lines of code but received errors on a few lines of code. The new lines of code are for adjusted cell columns, Range(aRng & Range("AXO2").Value & ":" & aRng &...

I'm not getting the uRng in the Intersect without an error. The error is 1004: Method Range of object_Worksheet failed. This is the code I want to use (it is for making a time in an excel cell without using the : character): <code style="margin: 0px; padding: 0px; border: 0px; font-family...

Private Sub Worksheet_Calculate() Dim aRng As Range Dim aCell As Range Set aRng = Range("AE9:AE92") For Each aCell In aRng If aCell.Value = "Yes" Then Call HitIt Exit Sub End If Next For Each aCell In aRng If aCell.Value = "No" Then Call HitIt Exit Sub End If Next End Sub Private Sub...