kshitij_dch
Active Member
- Joined
- Apr 1, 2012
- Messages
- 362
- Office Version
- 365
- 2016
- 2007
- Platform
- Windows
Hi
Hopefully someone will be able to help
I have a worksheet and i need some <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> code that will copy a particular range in a column(between columns A to O).
As macro finds a word "Copy" in range A1:O1000, it should copy from Cell that contains word "Copy" uptill 100 cells downward and paste that copied range in a new workbook.
is anyone able to help?
many thanks
Hopefully someone will be able to help
I have a worksheet and i need some <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> code that will copy a particular range in a column(between columns A to O).
As macro finds a word "Copy" in range A1:O1000, it should copy from Cell that contains word "Copy" uptill 100 cells downward and paste that copied range in a new workbook.
is anyone able to help?
many thanks