Thread: [Solved] Allow spacing between cells.
View Single Post
 
Old 10-27-2016, 03:01 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
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

This checkbox doesn't get recorded and there isn't an obvious command to turn it on or off in the vba intellisense. The best I can come up with is to toggle the space to zero
Code:
  With Selection.Tables(1)
    If .Spacing = 0 Then
      .Spacing = CentimetersToPoints(0.5)
    Else
      .Spacing = 0
    End If
  End With
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote