Hello,
I am trying to find a vba code that will find blank cells in a certain column, and replace these cells with a formula that includes the range of cells above (up until the next blank cell)
for instance, cells C3:C15 are filled in, C16 is blank, I want a code that can find the blank C16, and insert the following code:
countif(C3:C15,"*C*")/ counta(C3:C15)
Thank you so much in advance!!
Configuration: Windows XP Internet Explorer 7.0
Excel copy cell if formula Excel find a word in various cells Excel formula find all cell that contain specific word Excel formula to count non blank cells and dispaly in other sheet Excel pass cells to formula Excel use macro insert formula cell Excel vba find first blank cell Find ,match,copy , paste, insert Find perticular entry in range of cell as insert adjacent text in next cell, excel Formula to format cells How to hide rows of blank cells of different columns a:d vba Insert blank cell to match rows in excel Macro find a blank cell Macro to find if the cell has integer Read and highlight the reference cells in formula Read the reference cells in formula Vba find match entire cell content When you select a cell insert current time