nicolaforni
05-19-2011, 03:42 AM
Hi,
I created a code whereby I start in sheet1 then I go into a sheet2 then I do a shift-F9 and then I go back to original sheet. Very simple and it works. I then copy this code and paste it in a Command Button and I get the error message "Select method of range class failed".
Can someone explain why?
:dunno
Code below:
Sheets("Sheets2").Select
Application.Run "BLPLinkReset"
Range("B14").Select
ActiveSheet.Calculate
Sheets("Sheets1").Select
Application.Run "BLPLinkReset"
Range("C19").Select
End Sub
Thanks!
Nic
I created a code whereby I start in sheet1 then I go into a sheet2 then I do a shift-F9 and then I go back to original sheet. Very simple and it works. I then copy this code and paste it in a Command Button and I get the error message "Select method of range class failed".
Can someone explain why?
:dunno
Code below:
Sheets("Sheets2").Select
Application.Run "BLPLinkReset"
Range("B14").Select
ActiveSheet.Calculate
Sheets("Sheets1").Select
Application.Run "BLPLinkReset"
Range("C19").Select
End Sub
Thanks!
Nic