Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Create different workbooks from workbooks | Excel Worksheet Functions | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) |