Multiple formulas that always find the end of data.

[holyasian]

To all,

The spreadsheets I work with always vary in length and I am trying to make a macro that always references all of my data. Any quick Google search would return a good answer to my problem, but this macro contains several different if functions with nested indexes. Here is my code. I bolded the formulas I'm having problems with. The rows they are currently referencing are the last rows in their respective spreadsheets. Yes I did record this macro, so laugh now.

Please Login or Register  to view this content.

Any help on this issue would be great.

Thanks!

[tigeravatar]

holyasian,

Thank you for adding the code tags. Give this a try:

Please Login or Register  to view this content.

[holyasian]

Doesn't work exactly right, but that's only to be expected for not including my workbook. However I can still use your methods for finding the last rows and incorporate them into my project. Thanks for help!