named ranges question

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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 ?
 
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
 
Back
Top