LinkBack URL
About LinkBacks
Hello,
I am trying to write a program to delete a row if column J contains any sort of text. The text in column J is not the same. Any help is appreciated!
TIA
Hello,
I am trying to write a program to delete a row if column J contains any sort of text. The text in column J is not the same. Any help is appreciated!
TIA
Last edited by tactical; 05-30-2012 at 03:24 PM.
*Untested*
Please make a copy of your workbook and test on the copy. If you are unfamiliar with how to run the code, please use the instructions in my signature.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I have used this one.
Columns(11) = "J"Please Login or Register to view this content.
Last edited by oeldere; 05-30-2012 at 04:44 PM. Reason: changed text used
Im getting a on Method 'Range' of object '_Global' failed error with this code.Originally Posted by AlvaroSiza
*Untested*
Please make a copy of your workbook and test on the copy. If you are unfamiliar with how to run the code, please use the instructions in my signature.
Please Login or Register to view this content.
I don't think it like the "If Application.WorksheetFunction.IsText(Range(rngCell)) Then" line
Last edited by tactical; 05-30-2012 at 04:54 PM.
J is actually column 10. I am getting Delete method of Range class failed error for this one
you are right => J= colomn 10Please Login or Register to view this content.
I send you my example.
first run macro
Sub delete_NOT_empty_row_in_columnC_oeldere()
then run
Sub delete_empty_row_in_columnA()
This one works fine for me.
Yours is working, but mine is not.you are right => J= colomn 10Please Login or Register to view this content.
I send you my example.
first run macro
Sub delete_NOT_empty_row_in_columnC_oeldere()
then run
Sub delete_empty_row_in_columnA()
This one works fine for me.
Maybe you can post your example, without personal information.
Then i can try your code on my PC.
Last edited by oeldere; 05-30-2012 at 05:45 PM. Reason: changed text
Here is my workbook.
Also, the number of rows always changes, therefore it would also have to work for more data entries.
Again, if a cell in column J is empty, I want to delete the row that corresponds to empty cells.
I appreciate your help!
Please Login or Register to view this content.
Harry.
This deletes the empty rows. What do I need instead of "" to make it delete rows that contain any string?Please Login or Register to view this content.
Use:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks