I have a workbook with numerous sheets; two of these sheets have private sub macros that run when a specific cell has a specific value. Let’s call these master sheet 1 and master sheet 2. After data is entered on master sheet 2, a final selection is made and master sheet 2 reveals the working sheets then hides from view. Then you are on master sheet 1, this is a form letter of sorts. It needs to be formatted differently depending on a choice made on master sheet 2 before it is hidden. After the choice is made and master sheet 2 is hidden, master sheet one finalizes the workbook. I wish to merge various cells on master sheet 1 depending on the value of a cell on master sheet 2. My choices for the trigger are: "mergetype1", "mergetype2", or left blank. Of course the trigger cell for the macro I wish to add is a different cell than the one for the existing macro. I've tried various formulas/codes; the one below is my latest attempt. I have even tried to add the macro to the existing macro on master sheet 1 although I need the trigger to be on master sheet 2. finally I tried all the different vba macro I could find on master sheet 2 as well, it made no difference...I have been totally unsuccessful in getting any macro or formula to merge at all, much less do all I wish it to do. Please help. Thank you

Please Login or Register  to view this content.