Macros in excel 2000

T

traineeross

I have a macro which i need to use on different spreadsheets where the data
is of various lengths.

I need to get the macro to go to one cell below the last active cell in a
column.

I have made the macro work for the first sheet where there are 1101 rows.
This is what the part of the macro looks like, i need the cell values
replaced with the code to go to the last active cell in row I and J and then
move down one-

Range("I1102").Value = "Over Two Days"
Range("I1103").Value = "Under Two Days"
Range("J1102").FormulaR1C1 = "=COUNTIF(R[-" & iLastRow - 1 & _
"C:R[-1]C,"">3"")"
Range("J1103").FormulaR1C1 = "=COUNTIF(R[-" & iLastRow - 1 & _
"C:R[-2]C,""<=3"")"

Look forward to the replies.

My thanks in advance Jody Williams
 
B

Bob Phillips

I showed you that previously


iLastRow = Cells(Rows.Count, "F").End(xlUp).Row


or any other column

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top