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