UDF for pulling value from previous worksheet

[bltnwp]

Hello,

I'm a first time poster long time forum diver. I am trying to write a custom function that will let me get a cell value from X many worksheets back. Something like =Functionname("X","N") where X = how many worksheets to go back and N = the cell address from which to pull the value. I have pretty minimal programming knowledge and have no idea where to start on this one. I usually look for code that gets close to what I need and manipulate it from there but can't find anything like this.........Anyone willing to take a stab at it? I am sure I will /facepalm due to it's simplicity.............

Thanks,

[DonkeyOte]

Questions:

what happens if the offset goes back beyond sheet1 (eg to non-existent sheet) - should this then revert to last sheet and work back from there ?

what happens if there are hidden sheets or chart sheets ?
should these be ignored in terms of the offset ?

The morefunc.xll add-in has a SHEETOFFSET function but it will be fairly straightforward to create your own UDF along similar lines - but the above should be outlined first.

[shg]

Here's one:

Please Login or Register  to view this content.

[bltnwp]

shg,

That UDF is perfect and so versitle! Thanks much for the help.