View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AndyGoz AndyGoz is offline
external usenet poster
 
Posts: 1
Default 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