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

Hello Roy,

You need to use "Named Ranges". Take a look at Chip Pearson's article:

http://www.cpearson.com/excel/named.htm

Best regards

John



"Roy Korb" wrote in message
...
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

Use a dynamic range

=SUM(OFFSET($A$2,,,COUNTA($A:$A)-1,COUNTA($2:$2))

will sum from A2 across and down.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roy Korb" wrote in message
...
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