Problems with Range

**Andy Pope** · 02-02-2009, 06:51 AM

So you just need to code for multiple cells.

Should each row in the target range have a formula applied?

What is the proper formula?

**tneva** · 02-02-2009, 07:06 AM

Originally Posted by Andy Pope

So you just need to code for multiple cells.

Should each row in the target range have a formula applied?

What is the proper formula?

Yes for every row where number gets added.

Formula is:

=IF(A303="";"";PIBVSearch(2;"server";"";"";"";"";"*-200 day";"";"";"S.0";256;PIBVUnitBatchSearchMasks(TEXT(A303;0);"";"";"";"")))

Where A303 is cell that got changed. Ultimately I will be wanting to change "*-200 day" to be date which is dependant on row above this which is why I'm going macro way(can't figure way to get it working by adding formula to cell itself. I can put date there but how to get it calculate from date above).

Result will be date and time.

**Andy Pope** · 02-02-2009, 07:10 AM

So something more like this.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rngCell As Range
    
    If Target.Column = 1 Then
        For Each rngCell In Target.Cells
            If rngCell.Value <> "" Then
                ThisWorkbook.Sheets("gg").Cells(rngCell.Row, 2).Formula = "=1"
            End If
        Next
    End If
    
End Sub

Change the formula to your formula with user defined functions.