Help me pleeeeeaaassseeee

[Woody75]

Hello,

I'm really new at this VBA stuff and was wondering if someone could help me. I'm looking to use a comd button to make excel do the following things:

1. Open a specific hidden sheet

2. Copy data from a range on hidden sheet and paste to different locations on other hidden sheets.

3. Print a specific hidden sheet using the default printer

Many Thanks

Woody

 

[shg]

Public Sub x()
    With Worksheets("Sheet1")
        .Visible = xlSheetVisible
        .Range("A1:A10").Copy Worksheets("Sheet2").Range("E5")
        .PrintOut
        .Visible = xlSheetHidden
    End With
End Sub

 

[Woody75]

So if i wanted to do a reset button. could i ise the with cmd again on different sheets?? eg open hidden "sheet1" carry out actions, print, rehide and end the with cmd. Then select another sheet using with cmd and do the same type of things again or can i be kept within the initial with cmd??? Hope i make sense...

 

[shg]

Sorry, I didn't follow any of that.

 

[Woody75]

for example:


Public Sub x()
With Worksheets("Sheet1")
.Visible = xlSheetVisible
.Range("A1:A10").Copy Worksheets("Sheet3").Range("A1:A10")
.PrintOut
.Visible = xlSheetHidden
End With
With Worksheets("Sheet2")
.Visible = xlSheetVisible
.Range("B1:B10").Copy Worksheets("Sheet3").Range("B1:B10")
.PrintOut
.Visible = xlSheetHidden
End With
End Sub</pre>

 

[shg]

If that works for you, it's golden.

 

[Woody75]

thankyou for you time