Cell reference within a sheet reference?!?!?!
Posted by Dustin on March 05, 2001 11:59 AM
Is it possible to use a cell reference within a sheet reference. I have a large sheet that contains almost one hundred sections of three repeating lines. Each line contains a sheet reference to another worksheet. I can save a bunch of time doing "find/replace" if I can figure out a way to use a cell reference (the cell referenced would contain the actual page name to be used in the sheet reference).
Thanks very much.