Error: Undefined or non-rectangular name

K

Kevin M

TIA all, i built a sheet a while ago that updates it's
status for all the employees. the one with the crew list
is having a problem updating. I don't know why, because
the sheet has worked flawlessly for over a year.
the two names on the crew list are as follows:
Rig:
='\\ocgpfile1\Local\PWS\Rigs\Daily Activity Report
mod.xls'!RigList
Status:
='\\ocgpfile1\Local\PWS\Rigs\Daily Activity Report
mod.xls'!RigStatusList

The other sheet that these two refer to goes like this:
RigList:
=OFFSET('Rig Report'!$A$9,0,0,COUNT('Rig Report'!$A:$A),1)
RigStatusList:
=OFFSET(RigList,0,7)

Any insights?
Kevin M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic lists, overlook spaces 0
Error: Undefined or non-rectangular name 0
How can I do this?? 1
non-rectangular name - definition? 2
matching data from 3 different sources 4
isolating different aspects of worksheets...as objects? through section breaks? 2
New Project, need idea to best approach it... 4
RON DE BRUIN: Help with CDO Please 1

Top