delete entire row by vba

**dumdumbum** · 07-14-2020, 10:13 AM

Hi Experts,
I am looking for a macro that will do the below things

Macro will be placed in macro.xlsm(so we have to open abc by a macro)
If column E matches with Column F then delete that entire row by vba
and save the changes & close the workbook
File ABC.xls may be located anywhere in the pc, so plz hardcode the path in the macro,so that i can change it as per my needs in future

Thnx For the Help

Sample file attached below

Hi Experts,
I am looking for a macro that will do the below things

Macro will be placed in macro.xlsm(so we have to open abc by a macro)
If column B of DEF.xlsx matches with Column I of ABC.xls then delete that entire row
and save the changes & close the workbook
File ABC.xls & DEF.xlsx may be located anywhere in the pc, so plz hardcode the path in the macro,so that i can change it as per my needs in future

Thnx For the Help

Sample file attached below

**alansidman** · 07-14-2020, 10:21 AM

Macro will be placed in macro.xlsm(so we have to open abc by a macro)

Why not use Personal.xlsb for your macros. See this link. It will save you from having to open file to run the macro. With Personal.xlsb, you can run macros on already open files.

https://www.rondebruin.nl/win/personal.htm

**dumdumbum** · 07-14-2020, 10:33 AM

Thnx for showing ur Great interest in this post AlanSidman Sir
I also know the macro to open a file by vba & save it too.. but i dont know vba completely Sir, So i tried to mention all the details in the post, So it should be easy for them to understand what exactly the needs is

**dumdumbum** · 07-15-2020, 09:47 AM

https://excelfox.com/forum/showthrea...4597#post14597

**maniacb** · 07-15-2020, 11:23 PM

For the first request in file ABC, here is code that will open a file ABC from some directory and then compare colmns E and F and delete that row if those values are equal. The code should be placed in the personal file as mentioned above.

Please Login or Register  to view this content.

**maniacb** · 07-15-2020, 11:27 PM

On the second request above, dealing with ABC AND DEF, when a match is found, should the row be deleted from ABC? file?

**dumdumbum** · 07-19-2020, 01:32 PM

thnx maniacb for helping me in solving this problem
Have a Awesome Day

**maniacb** · 07-20-2020, 05:15 PM

I have been advised to only delete columns from the bottom up, so I have updated the ABC code above. The For loop line please replace:

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

**dumdumbum** · 07-21-2020, 05:23 AM

Thnx Bro For ur Great Help maiacb

**maniacb** · 07-21-2020, 02:48 PM

Is the second question about DEF and ABC rows deleted no longer required and replaced by your subsequent request https://www.excelforum.com/excel-pro...ow-by-vba.html

If so, please mark this thread as solved.

**dumdumbum** · 07-21-2020, 03:57 PM

Yes I done the same maniacb Sir
This is also solved & that question is also solved & i marked both the threads as Solved
Sorry for the Trouble
Thnx Alot for helping me in solving the same Maniacb Sir

**maniacb** · 07-21-2020, 07:02 PM

No trouble, I am glad it has worked out for you!

delete entire row by vba

LinkBack

Thread Tools

Rate This Thread

Display

delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Re: delete entire row by vba

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] delete entire row by vba if delete word is present

iCell.EntireRow.Delete not working. Need code to Delete Entire Row

[SOLVED] Macro Needed to Delete Entire Row if the Entire Row (Or Col A,B,C,D in row ) are blank

VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

macro should delete entire rows which starts with "US" and etc ,should delete duplicates

[SOLVED] Delete cell only with certain critria. Don't want to delete entire row, the celsl only

Delete entire row when cell says delete

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions