I have different areas on the spreadsheet with naming definitions, and I use
the dropdown menu to select them. Is there any way to set up cells to go to
those named areas? Thank you in advance.

What do you mean by "go to these named areas"? Select them?

Tyro

"Mike Busch" wrote in message
...
I have different areas on the spreadsheet with naming definitions, and I
use
the dropdown menu to select them. Is there any way to set up cells to go
to
those named areas? Thank you in advance.

Mike

What do you mean by "cells to go to those named ranges"?

Cell contents, I presume.

You can use formulas to "pull" contents from other cells but formulas cannot
"send" contents to other cells.

Only by VBA code can you send contents.

Give us an idea and small example of what you what done.


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 15:41:00 -0800, Mike Busch
wrote:

I have different areas on the spreadsheet with naming definitions, and I use
the dropdown menu to select them. Is there any way to set up cells to go to
those named areas? Thank you in advance.