Hi Folks,
For Creating Quick Name Ranges short cut key is
Ctrl+Shift+F3+Enter
Below is the example table, when you hit Ctrl+Shift+F3+Enter it will create
Name ranges for Jan to Aug & Toyota to BMW (Note you should select entire
table and press above short cut key)
Jan Feb Mar Apr May Jun Jul
VBA Tips - Learn the name of the Windows user:
https://groups.google.com/forum/#!topic/excelvbamacros/-pvfIVv7cp4
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel