Results 1 to 16 of 16

Thread: Sleeper: If and Statement based on one cell and

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Sleeper: If and Statement based on one cell and

    I am trying to find a solution to If cell is >1 and the cell below is blank (""), then insert formula into specific cell location.
    Sub InsertSlopeFormula()
    Dim Cell As Range
    For Each Cell In Range("C1:C115")
        If Cell.Value > 1 And Cell.Value.Offset(1, 0) = "" Then
            Cell.Value.Offset(2, 0) = "a"
        End If
    Next Cell  
    End Sub
    Last edited by Aussiebear; 04-23-2023 at 03:54 PM. Reason: Added code tags to the supplied code

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •