Hoping someone can point me to some good resources, websites for working with tables in VBA. I have my range converted to a table, but now need to create 11 If statements and calculations to populate each of these 11 columns with a comment.
I can't seem to find any information on how to select the first cell in the specific table header, create the If statement, i.e. IF OpenQty >0 AND HaltCd <> AB,ZX,DE, "Issue1","NoIssue"
When those calculations and if statments are complete, I then need to concatenate all the comments into column A.
Any help would be appreciated.
Thanks,
Toni
Bookmarks