View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
acw acw is offline
external usenet poster
 
Posts: 19
Default Activiating and Selecting Excel Cells in VB.NET

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
.