Hello. Is there an easy way to adapt the code to do the opposite i.e. delete all rows that don't have at least one colored cell?

Thanks for your video I am having one doubt how to open password protected pdf file through vba

Please upload Selenium-vba -chrome webautomation examples

I want to change a phrase to another phrase, in many excel files in 1 folder at the same time, how to do with VBA excel?

You don't explain how do I identify the number of interior color.. How? Explain me please

Hello Sir, Recently, I've faced some problems in my office work. In order to solve those problems, I came up with 3 ideas. But due to shallow knowledge in VBA, I couldn't implement those ideas in reality to sort out those issues. I've given my 3 questions below one by one. I believe, you'll definitely help me. 001) Is it possible to create Spilled Array (Dynamic Array) like function in VBA. I mean to say creating User Defined Function like Spilled / Dynamic Array Functions (Filter, RandArray, Sequence, Sort, SortBy and Unique Functions) in Excel (Office 365 Version). 002) How do I split First Names, Middle Names (If Available) and Last Names with one single User Defined Function in VBA? Is it also possible in VBA? 003) How to use VBA Split Function with Multiple Delimiters?

Sir, I want to say, For last few days, I got stuck creating a VBA Code where I've to compile all the Data from Different Files. For your information, all the files are in the same folder. But, there are some catches, - 001) Each File has some Common Headers and some Uncommon Headers. I've to compile the Data Header wise. 002) Each File has more than 80,000 Data. And there are 28 to 31 files in that Folder depending on the number of days in that specific month. Now, during the compilation, if the row of the Master File exceeds 1 Million, then save it and close it. Create a new Excel Workbook, where compilation begins again. But, this time compilation should start next after where it ended in Last master file.

is conditional formatting through possible deleted rows.

Happy New Year in advance to you Sir and your Family. May this new year bring all the happiness in your life. Sir I'm requesting you to please make videos on these topics given below. No one has ever discussed on these topics on internet in great details so that we can understand them properly. Please make videos on these 3 topics. By the way, I'm very much impressed with your teaching style. Your way of teaching is unbelievable. Please keep my request. 001) Split Function in VBA with Multiple Delimiters like ";:*_, ./#@". I mean to say, how to split alphanumeric contents in Excel with split function in VBA those have multiple Delimiters. 002) How to convert Currency to Word through VBA? (Like 1,000,000 = One Million Dollar and Zero Cent Only) 003) How to find out Prime Numbers through VBA? (Like 3, 7, 11, 13, 17, 19, 23, 29 and so on).

Hi Dan. Thanks for the video. I solved it this way which allows you to select any sized range and the macro will loop through the cells in the selection and you don't have to worry about the size or keep track of the columns/rows. Just another way to solve it. Thanks for all the great learning at your channel. Thumbs up!! Sub DeleteRowsWithYellow() Dim rng As Range Set rng = Selection Dim cl As Range For Each cl In rng If cl.Interior.Color = vbYellow Then cl.EntireRow.Delete Next cl End Sub

Here's one of mine, which deletes all selected rows in range: Dim rw As Long, lastRow As Long, del As Long With ActiveSheet lastRow = .Cells(Rows.Count, 1).End(xlUp).Row 'find last row of Column #1 (A) For rw = lastRow To 1 Step -1 'loop through rows backwards If Not Intersect(Selection, Rows(rw).Cells) Is Nothing Then 'This row is within the selected worksheets range(s) Rows(rw).Delete 'delete row del = del + 1 'count deletion (only for troubleshooting) End If Next rw End With

Great job Dan. Thanks (krn14242)