Adding a variable range

[T De Villiers]

Hi,

Per attached I have a range of columns (variable) which I need to sum, the number of rows are also variable.
I have defined the variables:

firstrow
lastrow
firstcol
lastcol

I have tried the following code which isnt quite working, thankyou in advance.

Please Login or Register  to view this content.

[VBA Noob]

One way.

Please Login or Register  to view this content.

VBA Noob

[T De Villiers]

VBA Noob - thank you, works fine

[VBA Noob]

Care to mark it as solved then.

Goto the first thread > click edit > click advance > top right under the word "Title:" you will see a dropdown with the text No Prefix. Change to solved and save

VBA Noob