Make large chunk of If statements efficient. Array maybe?

By the way your original code does not compile. You need to use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

and you are missing "End If".

Thanks you for the initial help and the advice as well.

Hmm actually it is flagging some of the code as a problem:

Please Login or Register  to view this content.

With what error message? Compile time or runtime? If runtime, what is the value in C4? Very difficult to diagnose without having your file, attach if possible.

Might it be because its part of a range called Buttons? If so Im not sure I will be able to change it or take it out of the the range. Is there anyway to refer to the cell even though it is part of a named range without referring to the whole named range?

I don't understand your question--you are already referring to specific cells by cell address. This is not related to named ranges.

I can't help unless you can answer the questions I asked above and attach your file.

Sorry,
When I attempt to run the code i am presented with a "424 runtime error Object Required". I was saying before that C4 is parts of a named range called 'buttons' and was wondering if this effected it.

I found the problem is seems that if cell C4 is blank then the code runs into an error. Is there a way of making it so if the cell C4 is blank it returns the first value in the array instead of returning an error?

Add code in red

Please Login or Register  to view this content.