Thread: Macro help with copy/insert into mutiple workbooks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
galimi galimi is offline
external usenet poster
  
Posts: 210
Default Macro help with copy/insert into mutiple workbooks
Jason,

You could use the selection command
--
http://HelpExcel.com




"Hawkdriver" wrote:

I have two workbooks open and arranged horizontaly. I want to activate
workbook(2) select a range of rows with the mouse and then in workbook(1)
(thisworkbook) i then select the row that i want to insert above. i know how
to do this with activecell but how do i accomplish it when it is a range of
rows? Workbook(2) always has a different name and the range of rows selected
are always different.

Jason
Reply With QuoteReply With Quote