Activiating and Selecting Excel Cells in VB.NET

  • Thread starter Thread starter Zhichun Pu
  • Start date Start date
Z

Zhichun Pu

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
 
Zhichun

Range("a1").select

will take you to A1 in the current sheet.


Tony
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
What is the difference between 'Select' a sheet and 'Activate' a sheet 9
Select method failing 1
Move active cell through current selection 4
clear all sheets code 4
VBA Macro fails when Excel Not in Foreground 0
Excel Paste and VB.NET 1
Why does Sheet.Range("A1").Select not work!!! 2

Back
Top