Alternative to Indirect()

Thanks for the input Marvin.

I followed the thread and arrived here:
http://spreadsheetpage.com/index.php...a_closed_file/

The getvalue function though doesn't seem to be powerful enough for what I need it to do. Thanks for the suggestion, seems I will just need to use MoreFunc if ever, but likely I'll just scale down the automation of the spreadsheet.

my other problem is that we can't install stuff on our workstations here at work, but thanks for the suggestion Daddylonglegs. I will probably have to open a ticket requesting Morefunc to be installed standard to our workstations sometime.