I forgot to mention the reason that works for me is V22 and F-18 have a table with 9 columns wide, SOAR has one that is 15 columns wide. basically I want it to work no matter what the number of columns, but stop when the column is empty. if that makes since
Ok I have some code I have been using but depending on what I am working on I have to modify it. I am sure it would be easy for someone who knows javascript to do this. I do not use javascript. here is the code with my comments added when I was modifying it.
function AutomateExcel3()
{...