Vba to paste on a hidden sheet

[Azhar0554]

Is there is any possibility to paste data from one sheet to another sheet(That is hidden)

I have a vba code to copy data from one workbook on particular path and i have to paste that data into another workbooks sheet 6 but the sheet 6 is hided

Thanks in advance
Azhar

 

[Logit]

.
First unhide the sheet ... paste your data ... the rehide the sheet.

 

[Fluff]

You don't need to unhide the sheet

Range("A1:C5").Copy Sheets("Welcome").Range("F6")

This will copy from the active sheet to a sheet called "Welcome" which is hidden

 

[Azhar0554]

Thank you! i am using the same logic wanna know any other possibilities

 

[Azhar0554]

You don't need to unhide the sheet

Range("A1:C5").Copy Sheets("Welcome").Range("F6")

This will copy from the active sheet to a sheet called "Welcome" which is hidden

Thank you! I want to paste into an hided sheet

 

[Fluff]

If you just want values try something like this

Sheets("Sheet2").Range("A1:D5").Value = Sheets("Sheet1").Range("A1:D5").Value

 

[Azhar0554]

If you just want values try something like this

Sheets("Sheet2").Range("A1:D5").Value = Sheets("Sheet1").Range("A1:D5").Value

Thanks you!

 

[Fluff]

Glad we could help & thanks for the feedback