View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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 ?