ActiveSheet.Range("E2").value = Sum(ActiveSheet.Range(Cells(st, colStart), Cells(dn, colStart)))
The above "Does Not Work", but should give you an idea of what I am trying to do.
What I want to do is get the total of this range during the code execution so that I can place it in Cell E2.
If I use the Formula Method I get a #NAME? error.
Yours in EXCELent Frustration
KniteMare
PS. I found a great Animated.GIF (I saved it in my Private Drive, as the author does not want hyperlinking to his site to utilize these.)I want to use in my signature, how do I go about placing it there? PM With answer as It would seem to be a bit outside the normal disscussion group topics. Tnx in advance Knite.
This message was edited by KniteMare on 2002-09-20 12:23
The above "Does Not Work", but should give you an idea of what I am trying to do.
What I want to do is get the total of this range during the code execution so that I can place it in Cell E2.
If I use the Formula Method I get a #NAME? error.
Yours in EXCELent Frustration
KniteMare
PS. I found a great Animated.GIF (I saved it in my Private Drive, as the author does not want hyperlinking to his site to utilize these.)I want to use in my signature, how do I go about placing it there? PM With answer as It would seem to be a bit outside the normal disscussion group topics. Tnx in advance Knite.
This message was edited by KniteMare on 2002-09-20 12:23