Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macros in excel 2000
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 |
#2
|
|||
|
|||
Range("A65536").End(xlUp).Offset(1, 0).Select
"traineeross" wrote: 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 |
#3
|
|||
|
|||
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) "traineeross" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |