I'm using a statement like the following to fill some columns (minus
the header, row 1) with formulas or functions.

With ThisWorkbook.Sheets("sheet1").Cells(1, 1).CurrentRegion.Offset(1,
0)
.Columns(25).FormulaR1C1 = "=someformula"
end with

How can I use resize to avoid creating an additional used row at the
bottom? I've been fooling with it for a bit now, and I clearly am not
understanding it completely. The code works fine as is, but then I
have to go get rid of the extra row(s) afterwards.

Thanks!
Ward376