VBA Else If

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

With some help along the way I've put together the following code to perform various actions on selected columns within a sheet along the way.

Please Login or Register  to view this content.

Firstly, I admit the code may be a little clumsy, and I'm more than happy to be shown a more efficient way of writing this, but I have a problem with this part of the script:

Please Login or Register  to view this content.

Although this code is held in the 'Else' statement, does not perform the 'Conditional Format' and I'm at a loss as to why.

I just wondered whether someone could possibly look at this please and let me know where I'm going wrong.

Many thanks and the kindest regards

[Izandol]

You have not provided the sheet object for those ranges:

Please Login or Register  to view this content.

must be written as:

Please Login or Register  to view this content.

[Norie]

What happens if you change it to this.

Please Login or Register  to view this content.

[hobbiton73]

Hi, @Izandol, thank you very much for takingn the time to reply to my post. Thank you also for setting me straught with this. It now works perfectly.

All the best and kind regards

[hobbiton73]

Hi @Norie, thank you very much for taking the time to reply to my post and for taking the time to set me straight. The code now works perfectly.

May I also ask, because I'm fairly new to writing VB, could you perhaps tell me please, is there a more efficient way to write this. It looks a little clumsy that's all.

Many thanks and kind regards