I like to pick out a column that I know has data in it:

dim LastRow as Long
With worksheets("sheet1")
lastrow = .cells(.rows.count,"x").end(xlup).row
.range("a3:A" & lastrow).formular1c1 = .range("a2").formular1c1
end with

SharonP. wrote:

Can someone suggest simple (I'm a beginner) VBA code to identify the last
used row in a particular sheet? Then, once the last used row is identified,
use that variable to extend formulas on different sheets from row A2 to make
the used row number?

I'm working with a spreadsheet that is so large, I'm trying to fit the
needed rows with the input data which changes constantly.

Thanks!

--

Dave Peterson