James Perry
Member
Holding down the control key i select cells A1, B5, C8, D12, E17.
Still holding down the Ctrl key i use the Fill Color to fill all 5 cells with just one color and with one mouse click. In the same way i would like to fill all 5 cells with a common text value BUT unable to do so. So i'm using 3 lines of vba instead......
Sub AutoFillTextValue
For each cell in Selection
Cell.value = "testing"
Next cell
End Sub
My question.....
How can i replace the visual basic part with Excel.
Many thanks.
Still holding down the Ctrl key i use the Fill Color to fill all 5 cells with just one color and with one mouse click. In the same way i would like to fill all 5 cells with a common text value BUT unable to do so. So i'm using 3 lines of vba instead......
Sub AutoFillTextValue
For each cell in Selection
Cell.value = "testing"
Next cell
End Sub
My question.....
How can i replace the visual basic part with Excel.
Many thanks.