Offsetting a formulas result.
 

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?

Offsetting a formulas result.
 

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

"Patrick C. Simonds" wrote in message
...
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?

Offsetting a formulas result.
 

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



On Sep 8, 2:12*pm, "Patrick C. Simonds" wrote:
I should have mentioned, I can not put a formula in column H

"Patrick C. Simonds" wrote in ...



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?- Hide quoted text -

- Show quoted text -

Offsetting a formulas result.
 

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


On Sep 8, 2:52*pm, Susan wrote:
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

On Sep 8, 2:12*pm, "Patrick C. Simonds" wrote:



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

"Patrick C. Simonds" wrote in ...

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?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -