Hello
Simple question I think?
Do Excel & VB work in harmony, for example:
A sheet contains the calculation A + B = C
I run a VB script that changes the value of B.
Later in the same script (before it ends) I use the value of C.
I presume the sheet is recalculated instantly when VB makes a change, so that the new value of C can be used later in the same running script?
I have tried this out and I believe the answer is yes! But I just wanted to check for sure
Thanks
Robin
Bookmarks