I'm using SpecialCells to identify blank cells and setting:
Code: Select all
rngBlanks.FormulaR1C1 = "R[-1]C" '(to copy from the row above), and then
rngBlanks = rngBlanks 'to convert these to values.
Any idea why? Thanks, Andy.
Code: Select all
rngBlanks.FormulaR1C1 = "R[-1]C" '(to copy from the row above), and then
rngBlanks = rngBlanks 'to convert these to values.
Code: Select all
rngBlanks.FormulaR1C1 = "=R[-1]C"
For Each rng2 In rngBlanks
rng2 = rng2.Value
Next rng2