How to find last row

[js999]

Here is what I need help with...

I want to use VBA to determine the range of used cells on a worksheet so that I can then insert some formulas into the cells. I have used the following code to find the last row. But because I have an array formula in another sheet that references this sheet, I am getting the range as defined in the array formula.

Please Login or Register  to view this content.

Thanks,
js999

[jasoncw]

js-

Try this code for the last used row:

Please Login or Register  to view this content.

HTH

Jason

[royUK]

Here's another

Please Login or Register  to view this content.

You could make this a Function & use it like this

Please Login or Register  to view this content.

[js999]

Thanks for the responses jasoncw and royUK.

I ended up using the following code and it works nicely.

Please Login or Register  to view this content.

Thanks,
-js999

[jasoncw]

js-

Just a FYI, that will be just fine to find the last cell in a particular column. However, if you need to find the overall last row (for all columns), use the code I posted above.

Jason