VBA to merge cells

[slavmob]

Hi all,

I'm trying to merge cells based on a certain cell values. For instance, if column A was my helper and B-F represented the weekdays M-F, if the value in A was MT-WTHF I'd like to merge cells BC and DEF. Thanks for any help you can provide!

 

[oldbrewer]

in a macro you need to in effect say.....if cells B1 = M and B2 = T then merge B1 and B2

=left(A1,1) = M in the macro the code is =left(cells(1,1),1)

do a record macro and merge 2 cells then examine the code

 

[slavmob]

bump