Basic Hyperlink loop

**Smilykoch** · 10-04-2011, 04:15 AM

Hey guys..

I am very new to VBA programming, so it might not be the right way im trying to solve my problem here. Nevertheless i need some help figuring out why my code stops after first loop..

I have in my sheet a table, where i want to be able to make an "X" in column L with a hyperlink so i can delete that specific entire row..

the error is at : If Target.range.Address = "$L$" & Number & "" Then

Please Login or Register  to view this content.

**StephenR** · 10-04-2011, 05:15 AM

Probably because once it has deleted the hyperlink it is then looking for a non-existent target. Why do you need to use hyperlinks? Anyway, try this version:

Please Login or Register  to view this content.

**Smilykoch** · 10-04-2011, 05:17 AM

I dont really need to use hyperlinks, i just tought it was the easiest way to make a "button like" way of running a piece of vba code.. :o

**StephenR** · 10-04-2011, 05:22 AM

See above for re-worked code, but it would probably be easier to use double-click or right-click and then no need to add hyperlinks or anything like that.