![]() |
#3
|
||||
|
||||
![]()
Using Rows or Columns is problematic in non uniform tables. For that you will need to check each cell instead
Code:
Sub ExploreATable() Dim aCell As Cell, aRow As Row With Selection.Tables(1) If .Uniform Then For Each aRow In .Rows Debug.Print "Row: " & aRow.Index, "Cells: " & aRow.Cells.Count Next aRow Else For Each aCell In .Range.Cells Debug.Print aCell.RowIndex, aCell.ColumnIndex Next End If End With End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
tables;formula;automating |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
paik1002 | Excel | 6 | 09-20-2016 03:00 AM |
Combining 2 tables into 1 and use Table2's column widths (hoping for workaround dealing merged cells | CodingGuruInTraining | Word VBA | 24 | 10-07-2015 07:48 PM |
![]() |
wendyloooo | Word Tables | 1 | 05-26-2015 01:19 PM |
![]() |
tinfanide | Word | 3 | 11-24-2013 06:37 AM |
How to merge matching cells vertically? | Odiseh | Excel | 1 | 01-02-2010 02:41 PM |