All--I am working with an excel spreadsheet with several hundred rows and 60 columns. The column of the first filled cell in each row varies. For example, row 1 may have blank cells until column 5, row 2 until column 15, row three until column 3, row four until column 7 etc.

I need to fill all blank cells on the left of the worksheet (from first to last row) with the number 1. I could simply fill all blanks except there are blank cells on the right side of the worksheet that need to stay blank. row 1 may end with column 14 (15 thru 60 are blank), while row 2 goes to 30, and row 3 goes to 45, etc.... The empty cells on the right side need to stay that way.

My thoughts so far are to write a macro to count the number of empty blanks in each row with a Match statement...then somehow fill in those blanks using the result of the statement in each row...working my way down the spreadsheet. Any help or ideas that you can provide would be appreciated. I have worked a great deal with functions in excel but have a lot less experience with macros.

kim