Recent content by Bryan

Hi, sorry, looks like I didn't explain my problem properly. The merged cells go from B31 to P31, then B31 to P32 and so on till the last line at B47 to P47 for sheets 1 and 2 Sheet 3 is B31 to P31 down to last line from B47 to P47 Im guessing that is what is causing the run-time error 9...

I am hoping to get a macro that does the following. I need to clear data from merged cells on 3 different sheets in the same workbook . The range for sheet 1 and sheet 2 is B31 down to B47. Sheet 3 is from B37 to B47. I have tried every formula I could find to achieve this, but couldn't get any...