hi i was wondering if anyone could tell me why im getting a "Subscript Out of Range" error on this code??
this code is located in the Worksheet OnChange function of Sheet 2 "Corro"
Please Login or Register to view this content.
"discSelection" is sheet 16
any help would be much appreciated
Last edited by Aussiexile; 11-04-2010 at 02:23 AM. Reason: Solved
What does discArray(0) equal?
Arrays are always zero based.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
sorry i forgot i changed the range the range is actuallt A1:A31 and contains this list
1 - Client
A - Accounting & Finance
B - Procurement
C - Project Controls
D - Community Relations
EA - Architectural
EC - Civil
EE - Electrical
EG - Engineering Management
EH - Environmental
EJ - Control Systems
EK - Geotech & Hydraulic Engineering Services
EM - Mechanical
EN - Materials Engineering Technology)
EP - Plant Design & Piping
ER - Pipeline & Marine
ES - Structural
EU - Loss Prevention
EV - Process
EZ - Project Engineering
F - Project Management
H - Safety & Health
K - Administration
M - Management
P - Information Systems & Technology
PR - Public Relations
Q - Quality Assurance
S - Safety
TF - Construction
U - Startup
V - Contracts
DiscArray is a 2 dimensional array, 2 rows X 1 column.
TryOr without loopingPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mikerickson; 11-04-2010 at 02:27 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi,
Here is how you need to do it at: http://support.microsoft.com/kb/213798
The second example down.
Your both brilliant.
Thank you both for you help it is very much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks