AutoFill to start with Selected Cell
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" wrote in
message ...
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
|