View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
matt_steer[_5_] matt_steer[_5_] is offline
external usenet poster
 
Posts: 1
Default Using 2 open workbooks

still get subscript out of range !!!

I am using the following syntax...

Windows(wkbk1).Activate
Windows(wkbk2).Activate

where wkbk1 is a variable got from user selection

and wkbk2 is a variable assigned to the workbook from where the macr
is running

suggestions???

--
Message posted from http://www.ExcelForum.com