![]() ![]() MVP Tom Urtis is the founder of Atlas Programming Management, a full-service Microsoft Office and Excel business solutions company in Silicon Valley. SpecialCells(xlCellTypeBlanks).Formula = "=RC" ' For blank cells, set them to equal the cell above ![]() ' Turn off screen updating to improve performance ![]() Sample code provided by: Tom Urtis, Atlas Programming Management Sub FillCellsFromAbove() This continues down the entire column, filling a value down into each blank cell. The following example looks at column A, and if there is a blank cell, sets the value of the blank cell to equal the value of the cell above it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |