I use this macro to help name ranges.
Sub maketable()
Range("B19").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
ActiveWorkbook.Names.Add Name:=Application.InputBox("Enter Table Name")
End Sub
Is it possible to modify it so that it will run on all selected worksheets
(I select the worksheet via ctrl left click.
Thank you in advance.
Bookmarks