Select method of Range class failed
Posted by Franklin on January 30, 2002 3:37 PM
I have a macro that when I run from my PERSONAL.xls works fine, but when I try to copy and paste that code to a command button, I get a runtime error that says "select method or Range class failed". It debugs to a line that tries to select a range of cells. Can anyone tell me why I only get that error when running the macro from a command button and not as a straight sub from my PERSONAL.xls?
Thanks
Posted by Jack in the UK on January 30, 2002 3:47 PM
Hi
Two option i feel worth a try:
one change the macro name in command to sub testABC()
and save the excel sheet and assign the button to the new named macro
Or kill the same one in per.xls to do the rem it out all throught the code. or select all anc cut paste in word and save as back up macro whatever. so you can copy back..
the problem is excel is fighting with the same named scripts, could be wrong ... thats my call.
HTH
Rdgs
Jack
