How to merge rows, higlight the content of the merge cells and...

[codedreamer]

Hi,

I need to merge a block of text(rows and columns), highlight the merge cells and move that to a column on a different spreadsheet in a different book.
I have the merge and highlight done using vba, how can I move this data?

Thanks,

codedreamer

 

[Hui]

Record a macro
Select the Range
Cut
Change window to the other workbook
Paste
Stop Recording

cleanup the code

 

[codedreamer]

Record a macro
Select the Range
Cut
Change window to the other workbook
Paste
Stop Recording

cleanup the code

Thanks Hui,

codedreamer