Range("cell_name").Calculate works ok
but Cells(r, c).Calculate did nothing to a calculation yesterday (so I reverted to calculating the whole sheet).
Is that the way it's supposed to be? Seems a little odd.
EDIT: Hmmm, I just did one manually in the Immediate window, and it did indeed recalculate the cell (as you would expect). Musta been one of my dopey errors yesterday.
Last edited by FenceFurniture; 01-13-2021 at 08:27 PM.
Maybe you want to mark the thread as Solved, given you seem to have answered your own question?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks