Why does Excel take me to a random ‘unlocked’ cell during a GOTO operation

  Kiến thức lập trình

I specify going to a specific range during an APPLICATION.GOTO REFERENCE=Worksheets(“”).Range(“”) statement and I set the SCROLL parameter =True, but, Excel finds the first unlocked cell and goes there instead.

How do I get it to ignore unlocked cells and go to the specified range. I understand setting Scroll=True should orient the range in the upper left corner of the open Excel window.

I haven’t tried anything yet. I’ve looked in Visual Basic Help for the GOTO statement, but, the issue is not addressed anywhere…that I can tell.

LEAVE A COMMENT