deja2000
12-17-2008, 08:26 AM
I am creating an Excel template for a report I run monthly. I would like to write code that will automatically fill all blanks with a specific value. In researching the code I have run into two problems:
The report will always have the same number of columns but will have a different number of rows each month based on how many shipments were made. I could not find code that allows for this so that I don't leave any rows out but also don't fill every cell in the worksheet.
I cannot find code that will input the text, ?null" into blank cells. Everything I can find to reference puts the value of the cell above into the blank cell.Please help
:help
The report will always have the same number of columns but will have a different number of rows each month based on how many shipments were made. I could not find code that allows for this so that I don't leave any rows out but also don't fill every cell in the worksheet.
I cannot find code that will input the text, ?null" into blank cells. Everything I can find to reference puts the value of the cell above into the blank cell.Please help
:help