Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Highlighting Duplicate Data in a Workbook
Hi, I agree with Skipvought, consolidate in one sheet all your data. Then here is what I would do to get all unique entries, highlight the whole column by clicking on the column name, in the Excel Toolbar, go to Data>Filter>Advanced Filter, click Copy to Another Location, click Unique Records...- clrc
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I end an Error Resume Next Procedure?
Hi...need your help. After my macro runs the ErrorCapture procedure, it still goes to the third line and runs all the codes after. I'd like it to stop after it runs the error capture. Below is the code. Sub Macro1() Call ErrorCapture 'SUB PROC Sheets("RAW SEGMENT REPORT").Select Hope you can...- clrc
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
