Forum

That's it! I changed AG20, above, to Range("AG20"). The syntax is different from Excel. I don't know why there are spaces between characters that woul...

This is too difficult to adapt for me. I wonder if I can give you the code and I have and then prevail upon you to add the lines I need to make it wor...

Sunny, What I'm actually doing is executing a few commands when a checkbox is selected. I have twelve checkboxes, one for each month of the year in...

Okay, that helps refine it. Now the code looks only for something in the first column. But if I want to check by date in Table 2, how do I do that? Ho...

So, any ideas?

Here's the attachment. Thanks

Thanks, Clark, that works really well. I found that if I converted B8:B15 to a table and inserted the table name in the code to replace B8:B15, it wou...

Sunny, I found the problem. I had entered the code and adjusted the cell references first, and then I unmerged cells F9 and F10. That caused the co...

I added MsgBox "Hello" but nothing displayed when F9 was changed. However, none of the other code throughout the workbook now works, either. I guess i...

They're the same codes you've already seen, the one in which, upon selecting the tab, A1 is selected. I just ran a little test. I copied the Settin...

Hi Sunny, So if the code crashed then Application.EnableEvents would be false? I didn't try resetting Application.EnableEvents=True. What line woul...

Thanks for this. It works great in the file you sent. I unmerged the cells in my source workbook, but when I copied your code to the sheet in my full ...

I should have said, F4 is a dependent validation list from cell F5. When I select F4 and make a different selection, I want cell F5 to clear. Also, th...