VBA code for selecting specific cells within a worksheet

[santhoshmrao]

Hello All,

I am a beginner in VBA and need some help from experts. It would be great if you could please let me know the VBA script to select only specific cells within a worksheet. To be more precise, on sheet 1 - A2, A6 and A10 cells are filled with red color. I want only those cells which are highlighted in red to be selected, copied and pasted to sheet2.

Regards
Santhosh

[ajryan88]

To select a specific cell, say A2, there are a few different ways to achieve this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

To select cells based on their colour, try the code in my attachment.

Hope this helps

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.