L

#### Legacy 362125

##### Guest

I am new to this forum and I am looking for some help if possible.

I have a worksheet which have VBA in it one of which references cell A2 and if that contains specific if it is true then pulls the value from cell H if not it pulls the value from cell G, I am also looking to copy the formula from cell J2 down to the last active cell

Here is the code - can anyone help ?

Code:

```
Sub Forecast()
Dim LastRowColumnA As Long
LastRowColumnA = Cells(Rows.Count, 1).End(xlUp).Row
Range("J2:J" & LastRowColumnA).Formula = IF(ISNUMBER(SERCH("Completed",A2)),H2,I2
End Sub
```

Thanks