Select range based on variable cell content

[NoCanDo]

Hi folks

I'm struggling to find an answer to my seemingly 'simple' problem.

Based on if the value in col A contains the characters "TT" I want to select the range starting with this cell and ending at the end at the end of the row I'm using (.End(xlRight) and then merge these cells, change colors etc. And then looping this through a 'range' so that it only occurs where the values occur.

I can amend various cells based on this idea, but am unable to identify the range and then merge the cells.

Please Login or Register  to view this content.

I apprecaite my code is very basic, but that's my level at present - but I'm trying.

Hope you can help.

Kind regards

NoCanDo

[shg]

Maybe like this (untested):

Please Login or Register  to view this content.

[NoCanDo]

Hi there shg

100% perfect. Thank you for prompt action in solving my problem.

Kind regards

NoCanDo