Excellent. Many Thanks👌. BUT ... it worked on the cells that are totally empty .. the cell that were empty but had a formula in the cell didn't delete .. any help
Hello - -thank your for a very good video. One question - is it possible to write a macro that deletes empty cells AND empty rows in the same operation?
Hey Abdul, there is two different ways of referencing worksheets. You can refer to their name or refer to their position in the worksheets tab. If you want to refer to their name then you have to reference the name in quotation marks, i.e., worksheets("name_of_worksheet"). If you want to reference their position, no quotation marks are needed, i.e., worksheets(3). Thank you for your question. I hope this clarified the issue for you!
You can essentially choose which row to take as the argument. In your case, if C4 was you criteria cell then the row would be deleted. If you choose D4 as your criteria cell then the row would not be deleted. Hope this helps!
Hello, this works great for when entire row is blank but not when the cell in the column is the only blank. Is there a way to fix the code to delete the row if the a cell in the column is blank? Thank you!
Thank you. This is an excellent video. How would I have this run automatically as soon as I paste the data to the worksheet? Also, how could I add another line to remove duplicates at the same time? Thank you so much.
@@FinanceNik Thank you. I have figured it out. Maybe you can do a video on list of names being added to a sheet that already has names but having excel only add new names on the list if you could understand that. I have a master list but i get another list everyday and want to add only the new names on that list automatically and delete the duplicates. Thanks. Keep doing awesome work.
@@exclusivelynyc Hey, may I ask whether your sheets also include information in terms of a ID, say a customer ID or must the sheet distinguish by first and last name?
@@FinanceNik the data that I need to clean does have an ID number associated with a name but it is not necessary for what I have to do. If it would help to keep the ID number to do what I need to do I can keep it. I hope to distinguish between different names because I need to put each name to a different floor in my building than calculate how many people are on that floor specifically, than how many people are in the building total. Hope you can understand this. Thank you for your help
Hey Danny, yes it sure is. I would recommend recording a macro while doing a vlookup and then copying the code into whatever vba script you would like to do
You explained each step so well, and I really love your "no hard code" idea!!! Thank you for such a effective tutorial💯🎆
Hey Nik, I was looking exactly this code, Thank you.
Hi Nik, a great video, thank you. Is there a way to delete rows which is empty but the cells have formulas. Thank you
Excellent. Many Thanks👌.
BUT ... it worked on the cells that are totally empty .. the cell that were empty but had a formula in the cell didn't delete .. any help
I'm looking for this code past two month, thanks for it.
Thank you for the warm feedback! Appreciate it
Very helpful, many thanks 😊
Hi !
how to automatically delete empty row / column immediately, after i cut & paste ?
Hello - -thank your for a very good video. One question - is it possible to write a macro that deletes empty cells AND empty rows in the same operation?
How do you deal with the first row, which the auto filter seems to ignore?
Hey Tony, you just start the for loop at i = 1, thus starting at the first row of a worksheet. Hope this helps
This is awesome buddy thank you
Thank you very much!
Is it possible only the some rows rather than entire row.. Expecting reply
Hi, in code &worksheets(1), do we need to add name of the sheet in bracket () instead of 1
Hey Abdul, there is two different ways of referencing worksheets. You can refer to their name or refer to their position in the worksheets tab. If you want to refer to their name then you have to reference the name in quotation marks, i.e., worksheets("name_of_worksheet"). If you want to reference their position, no quotation marks are needed, i.e., worksheets(3). Thank you for your question. I hope this clarified the issue for you!
@@FinanceNik thanks for your prompt reply, I will try from my end and let's see whether this will resolve my problem.
I am getting compile error:invalid use of property highlighting Range
Hi Arjun, maybe check if there is a minor spelling error somehwere in the code. That might solve it
Excellent...Nik
hi Nik, what if a row has 1 cell that has data .. example A4-C4 = blank, but D4 has data ?
You can essentially choose which row to take as the argument. In your case, if C4 was you criteria cell then the row would be deleted. If you choose D4 as your criteria cell then the row would not be deleted. Hope this helps!
Hello, this works great for when entire row is blank but not when the cell in the column is the only blank. Is there a way to fix the code to delete the row if the a cell in the column is blank? Thank you!
Hello Michael, yes there sure is a way. I'll make it my next vid!
@@FinanceNik thank you very much! Your videos are amazingly informative. Have a great day!
Thank you. This is an excellent video. How would I have this run automatically as soon as I paste the data to the worksheet? Also, how could I add another line to remove duplicates at the same time? Thank you so much.
Hey, I'll get into that!
@@FinanceNik Thank you. I have figured it out. Maybe you can do a video on list of names being added to a sheet that already has names but having excel only add new names on the list if you could understand that. I have a master list but i get another list everyday and want to add only the new names on that list automatically and delete the duplicates. Thanks. Keep doing awesome work.
@@exclusivelynyc Hey, may I ask whether your sheets also include information in terms of a ID, say a customer ID or must the sheet distinguish by first and last name?
@@FinanceNik the data that I need to clean does have an ID number associated with a name but it is not necessary for what I have to do. If it would help to keep the ID number to do what I need to do I can keep it. I hope to distinguish between different names because I need to put each name to a different floor in my building than calculate how many people are on that floor specifically, than how many people are in the building total. Hope you can understand this. Thank you for your help
Hi Nik, is it possible to use vlookup function in vba?
Hey Danny, yes it sure is. I would recommend recording a macro while doing a vlookup and then copying the code into whatever vba script you would like to do
@@FinanceNik great with thanks
Try worksheetfunction .Vlooukup(), all the args are just the same when working on the worksheet.