I need to count the number of records that my sheet has in it and then populate a trailer record after the last valid record in the sheet. The issue I have is that the sheet is in a workbook that contains many sheets. I can perform a DO loop looking for a ISNULL condition to accumulate my row count but it appears that I have to reference the sheet by name or number and the macro has to be generic enough that it can be performed on any active sheet within the workbook. I was thinking that there might be some Domain Object within Excel to get the active sheets name but I can not find a reference in the help files to do that. Any suggestions from the forum?