ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/231678-workbooks.html)

Tab

workbooks
 
Hi I am trying to start a work book I wish it to goto
the last used worksheet and if possible the last cell, I have tried usin
the goto in Edit but it don't work , how can I achieve this.
thanks in advance
tom

Eduardo

workbooks
 
Hi,
To go to the last cell in a worksheet press CTRL+END keys

"tab" wrote:

Hi I am trying to start a work book I wish it to goto
the last used worksheet and if possible the last cell, I have tried usin
the goto in Edit but it don't work , how can I achieve this.
thanks in advance
tom


Tab

workbooks
 
Hi Eduardo, thanks for that but sometimes I dont make my self clear I think
I would like to say open a workbook at Sheet1 and then possible put in a
macro that would take me to the next clear cell say on book 4 but this would
be changing as eack used area of the sheet was fill .
thanks for your tip though if you could help me further I would be
eternally gratful.
tom

"Eduardo" wrote:

Hi,
To go to the last cell in a worksheet press CTRL+END keys

"tab" wrote:

Hi I am trying to start a work book I wish it to goto
the last used worksheet and if possible the last cell, I have tried usin
the goto in Edit but it don't work , how can I achieve this.
thanks in advance
tom



All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com