Hi Members,

Greeting to everyone. I am new to this group and this is my first
posting.

I have multiple sheets (about 10 - sheet names end with a number) in
my workbook.
Each sheet has a different number of filled in rows and columns and
these sheets are subject to frequent revision. I want to assign the
sheet tab names to the active cells in each sheet and I will be using
these named ranges in my pivot tables.

If I define the names manually (using menu Insert -- Name--
Define... ), then every time I need to change the named area for each
sheet. Its taking lot of time for me.

Is there any smart way of defining the names using formulas?
If not, can some of you guide me on the VBA codes for this? ( I am
beginner to VBA programming).

Thanks in advance,
Ramesh.