I want to write vba code to calculate a specific range of cells instead of the whole sheet. What I have done so far is selected the range in xl, and in the name box given that range a name. I then am trying to reference that range name in my code. But it doesn't seem to be calculating the whole range? Should I be creating a range object in my code and using it to reference the cells. Or maybe it's a problem with my code:
Range("SimAvg").Calculate
"SimAvg" being the range name I gave the cells in xl. I'm using xl2k.
Range("SimAvg").Calculate
"SimAvg" being the range name I gave the cells in xl. I'm using xl2k.