Formatting Without Selecting Range

[DCSwearingen]

I have an associate who has a "template" he uses for scheduling our production. He frequently highlights and drags items in a schedule from one area (time frame) to another.

When he does this he end up with the default border formatting in the area he dragged from.

I created a simple macro for him that will reformat his work range to the original settings.

Please Login or Register  to view this content.

There are a couple of specific ranges with similar, but different border formats.

My question is: How do I accomplish the formatting of borders without actually selecting the range.

He would like to have a button that will do the formatting, but not end up with the active cell changing when he is done.

This worked for me:

Please Login or Register  to view this content.

[Leith Ross]

Hello Dennis,

This macro will format your ranges without selecting them. It places a box around the cells, but this is to give you an idea how to do this. Change the worksheet name in blue to the worksheet your reformatting.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[DCSwearingen]

Good afternoon Leith!

Thank you for your help!

I played with your code to adapt to what my associate wanted to happen. Here is how I ended up:

Please Login or Register  to view this content.