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

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
>
>