make exel open at the bottom of the worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger S - 30 Oct 2006 16:08 GMT

I have a problem. Every time I open a worksheet excel it starts me off at
A86. I need to know how I can make it open and start me off in the first
empty colum

Reply to this Message

Don Guillett - 30 Oct 2006 16:21 GMT

Assuming you want to search row 1, right click sheet tab>view
code>copy/paste this>SAVE
now each time you activate the sheet it will open at the next empty column
in row 1

Private Sub Worksheet_Activate()
Cells(1, columns.Count).End(xlToLeft).Offset(, 1).Select
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I have a problem. Every time I open a worksheet excel it starts me off at
> A86. I need to know how I can make it open and start me off in the first
> empty colum

Reply to this Message