I like to pick out a column that has data in it and use that to determine the
lastrow.

Dim LastRow as long
with worksheets("sheet99999")
lastrow = .cells(.rows.count,"A").end(xlup).row
.range("C1:C" & lastrow).formula = "=yourformulahere"
end with



BRC wrote:

I have a macro that fills a range(column-a) with dates. the number of
dates can very from 2 - 210.
the macro then fills column-b with a lookup value from a range in the
workbook.All works fine to this point. next i want to put another
formula in col C beginning one row below the first date and going
through the end of the dates. So if column a1-a10 has dates I want to
put the formula in cells c2-c10.
I am not sure how to test for cell in column a (or b) is greater than""
. thanks for any suggestions.
BRC

--

Dave Peterson