After tinkering with
the Cells(30,10).Select, I have found that I can get it to work if I
define it a Activesheet.Cells(30,10).Select. This could be a solution
- It is also hanging when I attempt to select ranges using
"Range(Cells(1,1),Cells(2,2)).Select", for example. I left that
'problem' at work, and will have to pick it up tomorrow. I am thinking
I can probably mention the worksheet somehow in these types of
statements too and get this thing off the ground again (at least I
hope I can!).
Now that I think of it, this code in my test file was in a module, and
I tied it to a button when I brought it over into the actual file it
was to be used in. Would it make any difference if the code is running
from a command button on another worksheet, and as such, is tied to
that worksheet as opposed to being in a module tied to the workbook??