icntr

All, I'm looking for some help... I've followed this tutorial: the third list https://vbaf1.com/programming/cascading-dropdowns-useform/ ANd have expanded it to allow for 4 listboxes (from 3) - however the slight issue I'm having is that the third listbox is displaying duplicates and I'm not...

The code below deletes rows if column B is empty. It works fine but does about 1 or 2 rows per second and it sometimes has to go through a couple thousand rows. I never know how many rows will be in my file - sometimes 1000, sometimes 4000. I set the limit at 4500 but it's possible there...

There are 6 columns and I'm using autofilter to filter from 2 columns, however I want to copy and paste another column (after filtering) to a text file. ' Getting the day of the current date var = Day(Date) 'Autofilter ActiveSheet.Range("A:F").AutoFilter...

Good day lads, I have this code For iCntr = lRow To 1 Step -1 If Cells(iCntr, "L") = "Close" Then Rows(iCntr).Delete End If...

I have a report that I have to publish every week. I also use MS Excel 2010. How do you delete columns with a value of 0 starting in row 2, also starting from column N (or anything after column 14)? My report has a header but it will constantly change and I will continue to add columns after...