Need to calculate specified worksheets using VBA but code not working..

[pinkpeace7]

Hi there

I'm using a commandbutton to calculate specified worksheets and cells. My Command Button is in Sheet1 and I need to calculate worksheet 2 and 6. But with the code below, only worksheet 2 is being calculated... Worksheet 6 is not calculated when I try running it.. Any idea what is wrong with the code? Thanks!

Private Sub CommandButton1_Click()
    Worksheets(2).Calculate
    Worksheets(6).Calculate
    Range("B20:C22").Calculate
    Range("F30:T32").Calculate
End Sub

[pinkpeace7]

Thanks, I have done that! Any advice will be appreciated!

[pinkpeace7]

Anyone can help to see if my code is correct as VBA is very new to me..
I need both worksheets 2 and 6 to calculate when I run this macro.. but when I did, only worksheet 2 is being calculated..

[pinkpeace7]

Hi there

I'm using a commandbutton to calculate specified worksheets and cells. My Command Button is in Sheet1 and I need to calculate worksheet 2 and 6. But with the code below, only worksheet 2 is being calculated... Worksheet 6 is not calculated when I try running it.. Any idea what is wrong with the code? Thanks!

Private Sub CommandButton1_Click()
Worksheets(2).Calculate
Worksheets(6).Calculate
Range("B20:C22").Calculate
Range("F30:T32").Calculate
End Sub

Sorry about earlier.. Is this correct or do I need to submit a new thread? Thanks!