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

**pinkpeace7** · 02-26-2014, 04:14 AM

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!

Please Login or Register  to view this content.

**pinkpeace7** · 02-26-2014, 05:21 AM

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!

Please Login or Register  to view this content.

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

**pinkpeace7** · 02-26-2014, 10:03 PM

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

**pinkpeace7** · 02-27-2014, 09:45 PM

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