Row Color

[Guest]

I have Row 31 (the entire row) in my worksheet in color and would like it to
remain as is. However Ill be cutting and pasting from other cells into cells
that lie in this row. When I cut and paste into the colored row the cell in
Row 31 changes to white. How can I cut and paste into my colored row
retaining the color by simply cutting the value and not the actual color???

 

[Guest]

Try Ediy>paste special>value
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

Thank You John. That solved my problem

Try Ediy>paste special>value
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Gord Dibben]

How did that solve your problem?

Paste Special is not available when "cutting" cells, only when "copying".

Unless you are doing it two steps

1. Copy>paste Special>Values.

2. Go back to original cell and clear it.


Gord Dibben MS Excel MVP

 

[Guest]

Do you know of another method Gord?

How did that solve your problem?

Paste Special is not available when "cutting" cells, only when "copying".

Unless you are doing it two steps

1. Copy>paste Special>Values.

2. Go back to original cell and clear it.


Gord Dibben MS Excel MVP

 

[Guest]

What if I want to add this feature to a macro??? How would I go about it
Any further help appreciated

 

[Gord Dibben]

Sub foo()
Dim rng1 As Range
Dim rng2 As Range
Set rng1 = Selection
Set rng2 = Application.InputBox(Prompt:= _
"Select Any Cell to paste to", Type:=8)
rng2.Value = rng1.Value
rng1.ClearContents
End Sub


Gord

 

[Guest]

Thank You
Sorry for the late reply

Sub foo()
Dim rng1 As Range
Dim rng2 As Range
Set rng1 = Selection
Set rng2 = Application.InputBox(Prompt:= _
"Select Any Cell to paste to", Type:=8)
rng2.Value = rng1.Value
rng1.ClearContents
End Sub


Gord