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
|Excel: Find text between 2nd hyphen and next space||10||30|
|Move entire row to another workbook based on cell value||20||45|
|Extract strings / characters from the right till the second occurrence of the underscore character||9||45|
|Need VB Script to scan through XML file and export content to csv file||9||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!