Search:

Type: Posts; User: Andrew Lockton; Keyword(s):

Search: Search took 0.90 seconds.

  1. Replies
    4
    Views
    1,251

    It seems to work if you ensure you are passing in...

    It seems to work if you ensure you are passing in an integer
    .HorizontalAlignment = Int(rCel.Offset(1, j - 1))
  2. Replies
    4
    Views
    1,251

    Try this loop For j = 1 To rTbl.Columns.Count...

    Try this loop

    For j = 1 To rTbl.Columns.Count
    With rTbl.Columns(j)
    .ColumnWidth = rCel.Offset(0, j - 1)
    .HorizontalAlignment = rCel.Offset(1, j - 1)
    ...
Results 1 to 2 of 2