Offsetting a formulas result.

[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?

 

[Patrick C. Simonds]

I should have mentioned, I can not put a formula in column H

 

[Susan]

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

 

[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