It is really important to find the last row in excel data table when you do the VBA programing. To do calculation and finding or comparison you will need to automatically find where is the last column or row in your table. VBA is a good option for that