Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to figure out how to select the current cell, and copy the
formula down one row. I am playing with: For i = 3 To iLastRow + 1 If ActiveCell.Offset(-1, 0).Value < ActiveCell.Offset(-1, -1).Value Then ActiveCell.Offset(1, 0).Select Selection.AutoFill Destination:=Range("C2:C" & Cell.Row + 1), Type:=xlFillDefault iStart = i End If Next i Something seems to be failing here, and I can't tell what it is. Can anyone tell me? Thanks, Ryan-- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |