VBA Thick borders around select dates

[jsneak]

Afternoon everyone,

Wondering if anyone could help me with a calendar I've got. I've been able to do the border via conditional formatting - however you can only make thin borders (Which you can hardly see as this will need to be printed)

I was wondering if there was a way in vba to look at a range of dates and place a thick border around them?

Any input would be great, thanks!

[Winon]

Hello jsneak,

Why don't you just change the Color of the Cell Border?

That would be the easiest and fastest solution.

Regards.

[jsneak]

I might have to do that...

I've tried loads of different things, i've got some VBA that will put the border around a cell, i just cant get the VBA to select the dates from the formulas in the months.... Would there be a way of using INT in VBA?? A bit like the conditional formatting i've got on that page?

Thanks for the reply though

[Winon]

Thank you for your response jsneak,

I am afraid that it won't work since Conditional Formatting will override the VBA attempt.

Regards.

[Fluff13]

If you are happy to turn each month into a named range, you could use something like (I used Jan, Feb etc as named ranges)

Please Login or Register  to view this content.

You'll need to remove the CF.

[Winon]

Hi Fluff13,

I thought of the same which you suggest, but then again, the OP will have to amend his Conditional Formatting to apply to Cell Interior Colors, and only delete the Conditional Formatting for Borders.
Do you agree?

Kind regards.

[jsneak]

That's brilliant, thank you. I'll have a play around with it now.

[Fluff13]

Hi Fluff13,

I thought of the same which you suggest, but then again, the OP will have to amend his Conditional Formatting to apply to Cell Interior Colors, and only delete the Conditional Formatting for Borders.
Do you agree?

Must admit I hadn't noticed all the CF for cell fill as the formulae are broken. But if the OP needs the fill that can be done in code & delete all the CF, or as you mention just delete the CF for borders.
As most of the formulae are broken it's difficult to know what they are for.

[jsneak]

Yeah that's because I removed the other dates lol ...there was a big list of them that went across.
I just wanted to see if there was a VBA way of doing it 👍😬

[Winon]

@ Fluff13,

Good work indeed!

Thanks for the feedback.

Regards.

[Winon]

Hello jsneak,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

You may want to award some Rep Points where you feel it is deserved, by clicking on the Star(*) bottom left of the Post/s you found useful.

Thanks.

[Fluff13]

@ Fluff13,

Good work indeed!

Thanks for the feedback.

Regards.

Thanks for that & the rep

[jsneak]

If you are happy to turn each month into a named range, you could use something like (I used Jan, Feb etc as named ranges)

Please Login or Register  to view this content.

You'll need to remove the CF.

Thanks for the input everyone.

Sorry is the "mmm" where you define the month? I keep getting Method 'Range' of object_ 'Global' failed..

[Winon]

Hello jsneak,

Try changing the "mmm" to "mm".

Regards.

[Fluff13]

Try it like this

[jsneak]

Perfect mate, thanks for all your help

[Fluff13]

Glad we could help & thanks for the feedback