named ranges question
 

I have a sheet that has formatted boxes of information in it. I would
like to carry over the entire format to another sheet using the name
of the range. Is this possible without VBA ?

named ranges question
 

Yes it is. Once you have named the range of cells, you can:

Edit Goto... and pick the name. The its just copy, move to the
destination, and paste/special/formats
--
Gary''s Student - gsnu2007k


"Chris" wrote:

I have a sheet that has formatted boxes of information in it. I would
like to carry over the entire format to another sheet using the name
of the range. Is this possible without VBA ?

named ranges question
 

or f5

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary''s Student" wrote in message
...
Yes it is. Once you have named the range of cells, you can:

Edit Goto... and pick the name. The its just copy, move to the
destination, and paste/special/formats
--
Gary''s Student - gsnu2007k


"Chris" wrote:

I have a sheet that has formatted boxes of information in it. I would
like to carry over the entire format to another sheet using the name
of the range. Is this possible without VBA ?