hiden sheet data.

[zabiullakhan]

How can i copy data of a hiden sheet throught VBA code? please help.

 

[SydneyGeek]

Assuming that Sheet3 is the hidden sheet...
You can either activate the sheet, or just refer to it. See code below.

Sub Activate_Hidden()
    Sheets("Sheet3").Activate
    
    Range("F6").CurrentRegion.Copy Destination:=Sheets("Sheet2").Range("A1")
End Sub
Sub ReferTo_Hidden()
    With Sheets("Sheet3")
        .Range("F6").CurrentRegion.Copy Destination:=Sheets("Sheet1").Range("A1")
    End With
End Sub

Denis

 

[zabiullakhan]

Thanks a lot will try working on this.