1. T

    Sort by Active Table, Help.

    Please help. I cannot get this macro to work.... I am trying to sort by the active table, criteria is column 1. Then I would like to add a second critera, column 5 of the table. I keep getting an error on the line... ".Sort.SortFields.Add Key:=Range([activeTable("Column1")])...
  2. Randall00

    Ok, so there's ActiveCell and ActiveSheet...but how 'bout ActiveTable?

    Hi there! This is about the ever-unfolding mysteries surrounding Tables from Office 2007 in VBA. The lovely piece of code below does a fine job of removing the Table style from Table1 and converting it to a normal range: Sub RemoveTableStyle() Dim oSh As Worksheet Set oSh =...

Some videos you may like

This Week's Hot Topics