VBA Format Multiple Ranges

[hobbiton73]

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

I'm relatively new to VB, so a lot of my code is very long winded, an example of which is below:

Please Login or Register  to view this content.

The code applies formatting to two ranges within a given sheet in my workbook, but as I mentioned at the start, it's messy and 'long winded'.

I just wondered whether someone with more experience, could possibly look at this please and offer some guidance on how I may be able to streamline the code.

Many thanks and kind regards

[ragulduy]

You can replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[hobbiton73]

Hi @yudlugar, thank you very much for taking the time to reply to my post and the guidance.

May I ask, is there a way in which I could streamline the coede any further.

Many thanks and kind regards

[ragulduy]

If you upload a workbook with a description of what the code is supposed to do, and the code in full. I could try and write it from scratch? I'd expect I would aim up with something very similar to what you have though.

That said, you don't need to do the ranges separately. For example, instead of:

Please Login or Register  to view this content.

I could do:

Please Login or Register  to view this content.

If you are unsure of the exact way to build the string to select the different ranges, you could always use union:

Please Login or Register  to view this content.

[hobbiton73]

Hi @yudlugar, thank you for your continued help with this, and my apologies for not replying sooner.

Your offer of re-writing my code is very generous, but I wouldn't want to put you to anymore trouble. I would also like to see this thorugh because I am very keen to gain my knowledge and confidence in writing the code.

Your last post was very inetresting because I wasn't aware of the

Please Login or Register  to view this content.

method of writing for multiple ranges.

All the best and kind regards

[ragulduy]

for info:
Range("A1,C3")
selects cells A1 and C3
Range("A1","C3")
selects cells a1,a2,a3,b1,b2,b3,c1,c2,c3

[hobbiton73]

Hi @yudlugar, thank you for coming back to me with this. This is extremely helpful.

All the best and kind regards