Hey all,
I'm a complete VBA beginner but I've been looking around on this forum and have been able to come up with code that deletes a row based on what is in a cell in VBA. Tried it out in a test document and worked great. Took it to the real document and it doesn't work due to (I think) the fact that the cell in sheet2 is a link to sheet1 in the workbook and only contains the link code and not the word i'm looking for to delete.
How do i delete the row based on the link's word that is showing in sheet2?
I'm a complete VBA beginner but I've been looking around on this forum and have been able to come up with code that deletes a row based on what is in a cell in VBA. Tried it out in a test document and worked great. Took it to the real document and it doesn't work due to (I think) the fact that the cell in sheet2 is a link to sheet1 in the workbook and only contains the link code and not the word i'm looking for to delete.
How do i delete the row based on the link's word that is showing in sheet2?