Automatically display specific Excel sheet & range

[wiginprov]

I have placed the following syntax in the general declarations section (VBA Project, Microsoft Excel Objects, ThisWorkbook) of a workbook, in an attempt to coax the file to always open with the cursor in a specific location, but it is not working. Does anyone have any suggestions?

Worksheets("Sheet1&quot.Activate
Range("A6:a6&quot.Select

 

[Goska]

Try this,

Worksheets("Sheet1&quot.Activate
Range("A6&quot.Select

And the right cell will be activated when the macro runs. It may be off the visible screen, and you may have to open the file and save it looking at the correct general area.

 

[segmentationfault]

If that works for ya, great, but I think you'll need something more like:

Sub Workbook_Open()
Worksheets("Sheet1&quot.Activate
Range("A6&quot.Select
End Sub

 

[wiginprov]

Thank you segmentationfault and Goska. That makes sense and IT WORKS! THANK YOU!