That's what I though! By "debugger" do you mean the "Show error" tool in the Advanced Editor? When I clicked that it highlighted the "if" in the if st...
Thanks Alan! I feel very silly but RefreshAll seems to work! Obviously the simplest solution, which I should have thought of ages ago. Will monitor th...
Sorry Catalin - I thought your answer had resolved the problem, but I've just returned to the file and tried to run the code again and found that it h...
Clearing the cache doesn't do it, but I think you're right about the problem being how the formula calculates. I think what's happening is that Power ...
Thanks Catalin! I knew it should - but could not see why it wasn't! That seems to have sorted it, thanks for your help
Hi Velouria - certainly not a stupid question! It's in both places. I initially noticed it in the query results (the query is loaded to a worksheet), ...
Thanks Alan - I was hoping that was only the case where the workbook was encrypted, but if not putting in some VBA shouldn't be too tricky. Just wante...