Offsetting a formulas result.

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

I would like to put a formula in Column AH (the formula would go down 500
rows) that would look at Column H and if it were blank place the text "NOT
CALLED" in column H. Is that possible?
 
a formula can only affect the cell it's in. so if you can't have a
formula in column H, as far as i know you're out of luck with
formulas.
i think you're looking at a macro.
hope that helps
:)
susan
 
Option Explicit

Sub Patrick()

Dim MyRange As Range
Dim c As Range

Set MyRange = ActiveSheet.Range("h1:h500")

For Each c In MyRange
If c.Value = "" Then
c.Value = "NOT CALLED"
End If
Next c

End Sub
'=======================
you could set this up as a button on the sheet & press it, say, before
exiting the sheet. or an auto_open sub that does it when you open the
sheet. or a worksheet_change sub that would work when things were
changed on the sheet.
lots of options.
susan
 
Back
Top