Thread: Applying a VBA code only on a selected table
View Single Post
 
Old 10-25-2021, 02:43 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
I would write it so it can do zero to n selected tables without needing to handle errors
Code:
Dim aTbl as Table
For each aTbl in Selection.Range.Tables
  With aTbl.Borders(wdBorderLeft)
    ....
  End With
Next aTbl
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote