Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help!!!! Selecting a cell in another workbook
Hi, I'm having a bit of trouble selecting a cell in a workbook.
I have a command button in my "home.xls" workbook I then save the Home work book: I open an existing "Destination.xls" I make the Destination Workbook active I then attempt to select a cell in the destination workbook...... at this point it all goes T*ts up and what ever i do to select a cell i get strange compiler messages and the debug window. I can select a cell in the home workbook, there must be a differen procedure for cell selection in a target workbook. Thanx Andy:cool -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help!!!! Selecting a cell in another workbook
Try
Application.Goto workbooks("Destination.xls") _ .worksheets("Sheet1").Range("A1") but in most cases there is never any reason to select a cell to work with it. -- Regards, Tom Ogilvy "AndyGoz " wrote in message ... Hi, I'm having a bit of trouble selecting a cell in a workbook. I have a command button in my "home.xls" workbook I then save the Home work book: I open an existing "Destination.xls" I make the Destination Workbook active I then attempt to select a cell in the destination workbook...... at this point it all goes T*ts up and what ever i do to select a cell i get strange compiler messages and the debug window. I can select a cell in the home workbook, there must be a different procedure for cell selection in a target workbook. Thanx Andy --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting a series of worksheets for printing not whole workbook | New Users to Excel | |||
Selecting used cells only in the workbook | Excel Discussion (Misc queries) | |||
Vlookup - Array not selecting in other workbook | Excel Discussion (Misc queries) | |||
Selecting the other open workbook | Excel Programming |