Hi Everyone,
I'm hoping this is an easy fix. I'm running a for loop that I want to overwrite a cell when a specific criteria is met.
Unfortunitly I am getting an error on the one line of code.
Can you help me out.
Thanks
Sub AddRunTime()
'
'
'
Dim JobNameCell As String, HoursCell

JobNameCell = "B"       '<======****** Change ******
HoursCell = "F"         '<======****** Change ******

Range("B1").Select              'Set start position

Dim lcell As Long
    For lcell = 1 To Range(JobNameCell & Rows.Count).End(xlUp).Row     'Set the range for the loop
        If Range(HoursCell & lcell) = "--------" Then
            If Range(JobNameCell & lcell).Offset(1) <> "" Then
                Range(JobNameCell & lcell).Offset(1).EntireRow.Insert
            End If
           Range(JobNameCell & lcell + 1).Value = "=================="  '<-------- This line gives me an error ****
        End If
    Next lcell

End Sub