Sorry I think I must be being a bit dense here.
I have 95 differently named workbooks and each of them have their file name
as the sheet name like dec01 dec02 etc. I have run a set process on a
dynamic range on each of them. I have written the sub routine to do this and
said reference "data" and up until now i have opened each file and manually
set the range name to Data, and it was this bit i was trying to speed up, so
it looks like i would still have to open and rename something in each file to
be cosistant any way is that right ? Sorry for asking so many questions but
this woud be a great help if i could crack this porblem


"karene" wrote:

How do I add a range name in an Excell macro to active workbook have several
with different name and record facilty keeps adding referes to xxxx in xxx
work book