insert vba code for Flash Fill into blank Excel 2010 worksheet and show me how to do it.
Budget: $10 – $30 USD
I am currently using Microsoft Office 2010. Flash fill came along in 2013.
Someone posted this code and said it seems to work.:
Code:
Sub FFvba()
Cells(1, 2) = "123-45-6789"
Dim rng As Range
Set rng = Range("B1:B4")
rng.FlashFill
End Sub
Someone posted this code and said it seems to work.:
Code:
Sub FFvba()
Cells(1, 2) = "123-45-6789"
Dim rng As Range
Set rng = Range("B1:B4")
rng.FlashFill
End Sub