Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Help with a script for IF with Cell Border LineWidth less than X, then put Y Help with a script for IF with Cell Border LineWidth less than X, then put Y
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 09-10-2022, 03:29 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Help with a script for IF with Cell Border LineWidth less than X, then put Y Windows 10 Help with a script for IF with Cell Border LineWidth less than X, then put Y Office 2019
Competent Performer
Help with a script for IF with Cell Border LineWidth less than X, then put Y 		 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default Dahhhhh, so true. Wow, I must be tired, makes perfect sens.
Quote:
Originally Posted by macropod View Post
The line:
Case 2 To 6: LineWidth = 8
does exactly the same thing as:
Case wdLineWidth025pt, wdLineWidth050pt, wdLineWidth075pt: .LineWidth = wdLineWidth100pt
You are so right. It's redundant.

OK let me try the above modified script. I'm thinking maybe it's because my operating system is in French, which I have not control on that. Believe me, I've tried many time to request an English operating system.

Thank god I truly LOVE my job.

Ok enough bla bla, let me test this. Crossing fingers.
Reply With Quote
 

Tags
helpme, if command, wdlinewidth

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell border lineweights bkcell Excel 0 08-20-2017 09:55 AM
Can I type over a cell with a border? Juju37 Excel 0 01-20-2015 07:40 AM
Help with a script for IF with Cell Border LineWidth less than X, then put Y Need to remove a line that isn't a cell border msbytes Word 4 08-15-2011 09:21 AM
Help with a script for IF with Cell Border LineWidth less than X, then put Y Cell border markg2 Excel 10 04-12-2011 05:05 PM
Help with a script for IF with Cell Border LineWidth less than X, then put Y Table cell border markg2 Word Tables 2 01-15-2010 05:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft