named cells. need a 101
 

I've been building a 'what if' sheet that pulls in this and that from
other sheets. All the sheets have named cells, as does the what if'
sheet itself. I want to copy/replicate this sheet multiple times in
the wb to allow for multiple and concurrent what if setups. I am
worried about named resources (cells) and what's going to happen when
I attempt this. I will experiment, but I'm worried about something
getting picked up in the wrong place. Is there a good 101 out there
that discusses the use of names and what to expect?

Thank you.

named cells. need a 101
 

There was an earlier posting regarding using the same name within a workbook
on different sheets. Essentially, it concluded that you would need to
modify
the "Names in Workbook" name to differentiate between different sheets,
since all names are at the workbook level and not the sheet level.
Otherwise, when you use Range("somename") in code, it would only apply to
the active sheet, which would involve some very meticulous code writing to
avoid putting or retieving data from different locations.


"cate" wrote in message
...
I've been building a 'what if' sheet that pulls in this and that from
other sheets. All the sheets have named cells, as does the what if'
sheet itself. I want to copy/replicate this sheet multiple times in
the wb to allow for multiple and concurrent what if setups. I am
worried about named resources (cells) and what's going to happen when
I attempt this. I will experiment, but I'm worried about something
getting picked up in the wrong place. Is there a good 101 out there
that discusses the use of names and what to expect?

Thank you.