Delete row based on a cell value that is a link

Dcrew11

New Member
Joined
May 31, 2012
Messages
7
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?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,211,853
Messages
6,104,371
Members
447,902
Latest member
chriswebs23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top