Thanks Leith,
I gave that code a try, however that seemed to copy the value in the first row down to the last in the selection overwriting any values in the middle. It should be copying down to the next non-blank cell, and then starting over with the new value it finds filling the blanks to the the next non blank.
I know these 2 samples I found partially work. but if the cell is formatted as text, it returns the "=R[-1]C" when it should be returning the cell value of that first non blank above it.
Both of these work if the cell if formatted as General. But if the formatting is Text it fails.
Bookmarks