Recent content by LPittenger

Here's an odd thing. With the tweaked code shown below -- using clearRegionRgn as an "intermediate" step between the string-represented address (clearRegion) and the .ClearContents command itself -- the debugger is reporting that clearRegionRgn is empty. That is to say, with code: 'IF...

Let me try a back-compatible zip version... hopefully this will work better? Thanks!

Thanks for the reply! I've got no Personal.XLS set up on the machine/user I'm working with, so nothing is being imported when I attempt the sheet. I can't (of course) speak to what might have been happening for the poster who reported that the sheet worked for them...

But it's the same exact sheet. I posted a copy of it and so they're presumably running exactly the same sheet (and VBA code and cell references) that I have.

Update -- I cross-posted over on http://www.excelforum.com/excel-programming/653595-vba-refuses-to-change-cells.html this morning. No solution there either -- but someone did run the sheet/book (which continues to fail when I try it) and reported it working. Which means there must be some...

Yup... here it is -- or, rather, a much shorter stripped-down version which preserves the code and problem.

I've got a VisualBasic routine set to clear one set of cells when a change occurs in another set. Everything works fine until it actually reaches the command to clear the cells. Stepping through in the debugger, I see that it has correctly found the proper range to clear and is looping through...