Using Variables in the sum() function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Korb - 26 Nov 2006 06:01 GMT

I export Quickbook reports to Excel spreadsheets they are of various
nnumber of columns and various number of rows. I want to use macros with
variables in the =sum() functions rather than the hard cell address. Is this
possible and if so how do I do it?

Thanks

Roy Korb

Reply to this Message

Zack Barresse - 30 Nov 2006 16:04 GMT

Hi Roy,

Why use macros at all? Is there a specific reason? A couple options you
have right off the top of my head is 1) create a dynamic range by using the
OFFSET function, or 2) use a defined named range which is dynamic. In
either of these cases, if you would like help with them, you'd need to
describe your data structure/layout, your formulas and how they would
change.

Signature

Regards,
Zack Barresse, aka firefytr

>I export Quickbook reports to Excel spreadsheets they are of various
>nnumber of columns and various number of rows. I want to use macros with
[quoted text clipped - 4 lines]
>
> Roy Korb

Reply to this Message

Rate this thread: