View Single Post
 
Old 07-13-2020, 05:09 AM
Matt32258 Matt32258 is offline Windows 10 Office 2019
Novice
 
Join Date: Jul 2020
Posts: 1
Matt32258 is on a distinguished road
Default

Dear Macropod, thank you for the well thought out VBA code. Unfortunately I experienced and error when attempting to run the macro routine. I am hoping that someone might offer advice in diagnosis the cause of the error.
The error message is: Run-time error '4605':
This method or property is not available because this command is not available inside math.
The command line where this occurred:
Set oTbl = Selection.Tables.Add(Range:=Selection.Range, NumRows:=2, NumColumns:=NumCols)

Thank you everyone. Cheers/M
Reply With Quote