Hi bobhc,
You are the second BOB (after Bob Umlas) who is showing me this trick..
Let me clear, I don't like to use MOUSE when working with Excel.
In fact I use Shift + F8 to select non-contigious cells.
b(ut)ob(ut) I fail when need to fill
bobhc 1, bobhc 2, bobhc 3... in next Row / Column, and Mouse passed with full marks..
I have lots of Shortcuts to work
*(Ctrl + ') - Fill Down Formula
*(Ctrl + ") - Fill Down Value
*(Ctrl + D) - Fill Down Formula + Value
* Alt + E + I + S (Edit > Fill > Series)
but none of them works in case of
Custom List or Word with Number Suffix.
I just want keyboard shortcut to
Code:
Selection.AutoFill Destination:=Range("A1:A15"), Type:=xlFillDefault
Thanks..