relative address

[Race1530]

if this is the formula

=sum(sheet26:sheet35!K4)

i understand it will sum the values of k4 on all sheets between 26 and 35
inclusive.

I want to copy that formula to sheet 46 and have it automatically change the
formula to

=sum(sheet36:sheet45!K4)

But when I copy, the formula remains static to the orginal. What am I doing
wrong. Thanks

Mike

 

[Frank Kabel]

Hi
Excel does not support this automatic change as you have described it.

 

[Harlan Grove]

Excel does not support this automatic change as you have described it.

...

Not with built-in functionality, but udfs can handle it. See my response to the
OP in the multipost in microsoft.public.excel.worksheetfunctions.

 

[Frank Kabel]

... it.
..

Not with built-in functionality, but udfs can handle it. See my response to the
OP in the multipost in microsoft.public.excel.worksheetfunctions.

Hi Harlan
I hate multiposts.......

nice UDF BTW

Best regards
Frank