• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy & Paste Highlighted Cells into another Worksheet VBA

Carah Granados

New Member
Hello,

I'm new to VBA and in need of help. I am basically trying to copy highlighted cells only and paste them into another worksheet. I would have a different range of cells to copy each time this VBA would be run because I would just keep adding to the list.

Thanks.
 

Attachments

  • Copy Highlighted Cells.xlsx
    9.8 KB · Views: 3
  • Paste Highlighted Cells.xlsx
    8.8 KB · Views: 5
Carah Granados
This would work for You ...
if 'Paste Highlighted Cells.xlsx'-file is in same folder as other file ...
if there are always nine columns and all rows to copy ...
if something different then ... this would need modification
>> Open Uploaded file and
>> Press [ Do It ]-button
 

Attachments

  • Copy Highlighted Cells.xlsb
    19.3 KB · Views: 7
Back
Top