Re: Counting Cells Within Vba
I'm not that good at VBA but, from looking at the code, I'd suspect the .double part because it looks like VBA didn't recognize it (or perhaps it would have capitalized it ".Double"). Using worksheet functions in VBA almost always comes down to getting the syntax right. Another trouble area is merged cells. You might try the same statement on cells that aren't merged and see what happens.