Saving format detail of entire row/column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to save and restore the formats of entire row and column.
Basically I want to write a SelectionChange event which would highlight the
current row and column. I'd much appreciate if somebody could help me with
the code.
 
Just use a helper column or row to store the formats:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/5/2007 by James Ravenswood
'

'
Columns("A:A").Select
Application.CutCopyMode = False
Selection.Copy
Range("N1").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
 
Asif, the only thing I can think of is to copy the entire column to another
column on the same sheet or a different sheet. Then, after manipulating the
column, you could restore the original formatting by copying the new column
and paste special over the original column, pasting formats only. You
should be able to record doing this so you can see how to do it. Same with
the row. James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving format of row/column 3
Highlight Row and Column headers of active cell 3
Automatically select entire rows on pressing down and up-arrow key 2
Retrieving Current Row,Columns & copying Format from Row,Columns a 2
Paste in column B using Last row of either column B, C or D. 10
Would love to write macro to delete any row that DOESN'T containspecific text.. 6
Run-time error when copying entire row! 5
If Then or Case help 3

Back
Top