tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a sheet with loads of areas all created by someone else who did not see the importance of merging cells,
So I have boarders that I cant simply change the colour of as it takes ages.
I need a macro that can change all existing boarders either on active sheet or in a specified range say "A1:AZ100" from existing colour to RGB 191,191,191 and if possible make them all thin lines
I hope this can be done please help if you know how
thanks
Tony
I have a sheet with loads of areas all created by someone else who did not see the importance of merging cells,
So I have boarders that I cant simply change the colour of as it takes ages.
I need a macro that can change all existing boarders either on active sheet or in a specified range say "A1:AZ100" from existing colour to RGB 191,191,191 and if possible make them all thin lines
I hope this can be done please help if you know how
thanks
Tony