Good afternoon. I am attempting to add some code to an already massive macro, but I am totally stuck. I have about 20 worksheets in this workbook; sheets 3 through sheets 17 are identical. Sheets 1 & 2 are summary sheets and 18-20 are background calcs. I need to format sheets 3-17 only, and depending on the region the workbook pertains to, the last row will always be different (it will be consistent throughout a single workbook, but I'll be running workbooks for different regions). So, for each workbook, I need to identify which is the last row of data on Sheets 3-17, and then format that row to BOLD. I need to find the last row on sheet 3 since some of the other sheets have "If/Then" formulas in every row down to Row 250, so finding the last row of data on those sheets doesn't work. I know how to find the last row on sheet 3, but how do I use that info on the remaining sheets? I think I need to set a variable like (Myvariable.Row), but I don't know how to use that in a command. Can someone help me write a macro that will format sheets 3 through sheets 17 that will bold the last row on each sheet? There are tons of examples on the net, but none that fit my need exactly. I was hoping I could just activate the last row on sheet 3 and then select sheets 3 through 17 and then say Selection.Font.bold = True, but I guess that will only work on the active sheet, not all subsequent sheets. Apparently I need to loop through every sheet. Any help is greatly appreciated. Thanks!