Hi,

For my first 12 worksheets I would like to add named range starting
from column I to Z.

say if my first 12 sheets are named as JAN thru DEC then what I am
looking for is a code to define range name from row 3 to 15 of each
sheet with sheet name and column name.

so for eg. in sheet JAN I3:I5 will be named as JANI and Z3 to Z15 as
JANK. this way for all 12 sheets

How can I do this?

Thanks