ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro help with copy/insert into mutiple workbooks (https://www.excelbanter.com/excel-programming/380028-re-macro-help-copy-insert-into-mutiple-workbooks.html)

galimi

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



All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com