Zhichun
Range("a1").select
will take you to A1 in the current sheet.
Tony
-----Original Message-----
I can't seem to do ANYTHING in VB. When I type in
something as simple
as,
currentWorksheet.Range("A1").Activate()
the program crashes and says the "Activate()" method has
failed. All
the other methods do the same thing. What is going on?
Thanks in advance.
Zhichun
.