Using variables as part of the "sum" function

**CarlidalRai** · 07-31-2010, 02:37 PM

Hi,
this from a complete Excel VBA novice....

Please Login or Register  to view this content.

The above code snippet works fine, using the hardcoded column numbers 1 and 9.

Question: The range of the "sum" function varies in my application, how would I use a variable instead of the hardcoded 1 and 9 ?

e.g.

Please Login or Register  to view this content.

which obviously gives me an error ?

**arthurbr** · 07-31-2010, 03:07 PM

Hi and welcome to the board

Your post does not comply with Rule 3 of our Forum [/I]RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Using variables as part of the "sum" function

LinkBack

Thread Tools

Rate This Thread

Display

Using variables as part of the "sum" function

Re: Using variables as part of the "sum" function

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions