Help with a script for IF with Cell Border LineWidth less than X, then put Y

BrianHoard · #2 09-07-2022, 05:41 AM

Something to try. What if instead of checking each cell for it's border size, you just set the entire table to 1pt? Would that speed things up?

As far as the Option Explicit issue, it simply means you have to declare each variable before you can use it. For example,
Dim objTable As Table
Dim someVar As Integer
Dim someVar As String
Dim someVar As Variant
Dim someVar As Object
etc

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
Need to remove a line that isn't a cell border	msbytes	Word	4	08-15-2011 09:21 AM
Cell border	markg2	Excel	10	04-12-2011 05:05 PM
Table cell border	markg2	Word Tables	2	01-15-2010 05:22 PM