Copy on visible cells only ...
 

Hi All,

I copy a range (5x5 cells, eg: a1:e5: Ctrl+C

I would like to paste this range on a New sheet on which column B & D
have been hidden. SO that my data appears on Column: A,C,E,F,G -5 rows
down.
The range becomes sort to say: A1:G5 (with no values in B & D-column)

Possible?

Cheers Sige

Copy on visible cells only ...
 

No this is not possible. However you can use a macro such as the following

Sub Test()
With Sheet1
With .Range("A1:A5")
.Copy Sheet2.Range("A1")
End With
With .Range("B1:B5")
.Copy Sheet2.Range("C1")
End With
With .Range("C1:E5")
.Copy Sheet2.Range("E1")
End With
End With
End Sub

Alok Joshi

"Sige" wrote:

Hi All,

I copy a range (5x5 cells, eg: a1:e5: Ctrl+C

I would like to paste this range on a New sheet on which column B & D
have been hidden. SO that my data appears on Column: A,C,E,F,G -5 rows
down.
The range becomes sort to say: A1:G5 (with no values in B & D-column)

Possible?

Cheers Sige