Selecting a Record and copying it to another Workbook
The records in my data are from Column s "A" to "M" inclusive. My code
selects the record I want in "A(x)" where (x) is of course the row number. I now want to copy the entire record from "A(x)" to "M(x)" and paste it to a separate workbook, How do I select the entire record for copying since the row number can be any row in my database. Dooley |
Selecting a Record and copying it to another Workbook
You didn't post YOUR code for comments but maybe this will help
ar=activecell.row range(cells(ar,"a"),cells(ar,"m")).copy -- Don Guillett SalesAid Software "Dooley007" wrote in message ups.com... The records in my data are from Column s "A" to "M" inclusive. My code selects the record I want in "A(x)" where (x) is of course the row number. I now want to copy the entire record from "A(x)" to "M(x)" and paste it to a separate workbook, How do I select the entire record for copying since the row number can be any row in my database. Dooley |
Selecting a Record and copying it to another Workbook
Don Guillett wrote: You didn't post YOUR code for comments but maybe this will help ar=activecell.row range(cells(ar,"a"),cells(ar,"m")).copy -- Don Guillett SalesAid Software "Dooley007" wrote in message ups.com... The records in my data are from Column s "A" to "M" inclusive. My code selects the record I want in "A(x)" where (x) is of course the row number. I now want to copy the entire record from "A(x)" to "M(x)" and paste it to a separate workbook, How do I select the entire record for copying since the row number can be any row in my database. Dooley Don; That was exactly what I needed! The code works perfectly! Sorry I didn't post my coding but you managed to decipher what I needed. Thank you very much! I appreciate yoour help. All ;the best in the New Year to you and yours! Dooley |
All times are GMT +1. The time now is 02:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com