Need help utilizing the lastrow type functions
 

Hey all.

I know how to get the last used row in a worksheet, or even the last row
used in a column, but lets say I am entering some columns in a table, and
formulas to these columns. However the issue I run into is. I enter the
formula, but I have no idea how to get it to fill down to the last row of
said column.

Any ideas?

Need help utilizing the lastrow type functions
 

Range(Cells(firstRow,yourColumn),Cells(lastRow,you rColumn).FormulaR1C1
= "=R[0]C[-2]+R[1]C[-2]"

Does that help?

Charles

havocdragon wrote:
Hey all.

I know how to get the last used row in a worksheet, or even the last row
used in a column, but lets say I am entering some columns in a table, and
formulas to these columns. However the issue I run into is. I enter the
formula, but I have no idea how to get it to fill down to the last row of
said column.

Any ideas?

Need help utilizing the lastrow type functions
 

Awesome thanks!!

You missed a closing ) before the .formulaR1C1, but not difficult to figure
out thanks!!!

"Die_Another_Day" wrote:

Range(Cells(firstRow,yourColumn),Cells(lastRow,you rColumn).FormulaR1C1
= "=R[0]C[-2]+R[1]C[-2]"

Does that help?

Charles

havocdragon wrote:
Hey all.

I know how to get the last used row in a worksheet, or even the last row
used in a column, but lets say I am entering some columns in a table, and
formulas to these columns. However the issue I run into is. I enter the
formula, but I have no idea how to get it to fill down to the last row of
said column.

Any ideas?