How can I use variables in =Sum(A1:C1) in a macro

[dschmitt]

the code below calculates the sum of the range B2 to F2 and puts the result into A2.

Assume I have variables (Integers) x and y which specify columns. X (2) specifies column B and y (6) specifies column F.

How would the code look using the variables to get the same result as the code below? That is get the result of the sum entered into A2.

Please Login or Register  to view this content.

[rwgrietveld]

Please Login or Register  to view this content.

This seems like the obvious. I would not use x and y but RowNr and ColNr instead. Does the B2:F2 need to be variable as well?

The you might be looking for something like:

Please Login or Register  to view this content.

[dschmitt]

Please look at the code. Then you know what I want. I want to know the correct coding for that.

Please Login or Register  to view this content.

[rwgrietveld]

I think this is what you need:

Please Login or Register  to view this content.

Goning to R1C1 style is easier in these cases.

OR

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[dschmitt]

yes, that does it. But there is still one problem left.

Your solution gives me:
=SUM($B$2:$F$2)

What I need is:
=SUM(B2:F2)

[rwgrietveld]

Use the last of my previous solutions: R[ ]C[ ] to have a FULL relative solution.