Using Array or Address selection in VBA Macro

Hi Experts,

I am trying to achieve the following using a macro. When I select few cells in a range and then I click on a button then the selected cells should populate some value as “Y” as shown below.

Block 1      

          Col1   Col2  Col3 Col4

Row1

Row2

Row3

 

Block 2

          Col1   Col2  Col3 Col4

Row1

Row2

Row3

When I select any range in the block 1 then the block 2 should populate a value Y for the Block1 selection. As block1 range selection is dynamic.

Request for your guidance

 

By: Rohit

Leave a Reply

Your email address will not be published. Required fields are marked *