May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
This works to filter the table, now I want to loop over the visible rows. How can I do that and also use the table column names to get values from the cells?
ActiveSheet.ListObjects(syncTable).Range.AutoFilter field:=EntIDColix, Criteria1:=enterprise_id ActiveSheet.ListObjects(syncTable).Range.AutoFilter field:=VMRUColix, Criteria1:=isVM ActiveSheet.ListObjects(syncTable).Range.AutoFilter field:=EntLOBIDColix, Criteria1:=enterprise_lob_id
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Macro to convert table into pivot tables||25||66|
|vba code to create folders according to a hyperlink||14||40|
|multiple unique values in different columns||15||31|
|Aggregate data in an EXCEL file.||11||28|
Join the community of 500,000 technology professionals and ask your questions.