Excel Cell Formats

Hi everyone:

I am trying to swap two cells completely, with each other, including value,
All formats, colors, etc. Well, swapping the values is easy. Does anyone
know, how I can swap All the formats (actual format, color, indent, etc)
that a cell can hold? Thanks for your help.

Bob


.

Relevant Pages

  • Re: Excel Cell Formats
    ... Dim C1 As Range ... I am trying to swap two cells completely, with each other, including value, All formats, colors, etc. ...
    (microsoft.public.excel.programming)
  • Re: MSForms.DataObject Misbehaving
    ... Here's one way to swap the contents and formatting of two ... Dim R1 As Range ... _swap_ the values and formats. ... X when pasting Range Y into it. ...
    (microsoft.public.excel.programming)
  • MSForms.DataObject Misbehaving
    ... I am trying to swap the contents and formats of two equally sized ... End Sub ... Any suggestions how to swap two ranges while keeping the ...
    (microsoft.public.excel.programming)
  • Re: how to convert 4 bytes into a float ?
    ... you have to swap bytes around. ... > formats, or Cray's original formats, or the like... ... here's a IBM 360 converter (at least that's what I think it is; ... from a PIL format converter for a format that uses "IBM floats"): ...
    (comp.lang.python)
  • Re: MSForms.DataObject Misbehaving
    ... _swap_ the values and formats. ... ie How can I store the formats in range ... X when pasting Range Y into it. ...
    (microsoft.public.excel.programming)