Applying this code to additional columns ?.

  • Hello,

    Code works for columns C & D, want to make the code work for columns H & I.



  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Note: no apostrophe in the tags, just used for demonstration here.


    your code goes between these tags


    Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • Change the Intersect section as below to H:I

    I've added code to ensure only one cell is selected to avoid errors if the selection spans both columns.

    I've simplified the code

    Make sure that you read and understand the Forum Rules before posting again.