My VBA looks for a cell first, then Selects another Cell in the same Row, and
then puts a Formula in the Active Cell,
and then I have a Problem trying to Auto-Fill this formula;
When dragging the Formula down I need to define a Range starting with the
Active Cell, and I can't seem to get this to work.
What do I put instead of "ActiveCell" in my Macro here below:

Columns("C:C").Select
Selection.Find(What:="NO", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Select
Cells(Selection.Row, "G").Select
ActiveCell.FormulaR1C1 = _

"=IF(COUNTIF(RC[-2],""*"")>0,IF(RC[-2]=RC[-6],""OK"",""WRONG!!!""),""@"")"
Selection.AutoFill Destination:=Range("ActiveCell:G7200"),
Type:=xlFillDefault

I would really appreciate any help on this, for which Many Thanks in advance!!
Hilvert

Brilliant, Just what I needed. Thank You very much indeed Mike!!

"Mike Fogleman" wrote:

> Destination:=Range(ActiveCell.Address & ":G7200")
>
> Assuming the Active cell is in column G.
>
> The following code will filldown the formula in E1 as far down column E as
> there is data in column D.
> Range("E1", Range("D1").End(xlDown)).Offset(0, 1).FillDown
>
> Mike F
> "Hilvert Scheper" <(E-Mail Removed)> wrote in
> message news:8B5C7007-34D0-4D8C-9D9B-(E-Mail Removed)...
> > My VBA looks for a cell first, then Selects another Cell in the same Row,
> > and
> > then puts a Formula in the Active Cell,
> > and then I have a Problem trying to Auto-Fill this formula;
> > When dragging the Formula down I need to define a Range starting with the
> > Active Cell, and I can't seem to get this to work.
> > What do I put instead of "ActiveCell" in my Macro here below:
> >
> > Columns("C:C").Select
> > Selection.Find(What:="NO", After:=ActiveCell, LookIn:=xlFormulas,
> > LookAt _
> > :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
> > MatchCase:= _
> > False, SearchFormat:=False).Select
> > Cells(Selection.Row, "G").Select
> > ActiveCell.FormulaR1C1 = _
> >
> > "=IF(COUNTIF(RC[-2],""*"")>0,IF(RC[-2]=RC[-6],""OK"",""WRONG!!!""),""@"")"
> > Selection.AutoFill Destination:=Range("ActiveCell:G7200"),
> > Type:=xlFillDefault
> >
> > I would really appreciate any help on this, for which Many Thanks in
> > advance!!
> > Hilvert
>
>
>