I'm building a compare using Excel and the macro is going to be used on all sorts of data sizes. Could be 100 rows, could be 2000 rows. I need to build into this macro something that can tell me where to stop. Right now, I have a sheet that is 1140 rows, but have the macro going to 1489. How do I get it to recognize the end of the sheet?
Here is my current macro....
' PreparePTCI Macro
' Keyboard Shortcut: Ctrl+Shift+P