Hi Cindy,

What do you mean by 'fill in the blanks' ?

Do you mean all the blank cells on a sheet or in a column or a row or a range?

If you know how write the code to fill in the blanks for your purposes, you could loop thru all the worksheets in your workbook and fill in the blanks for each one in turn.