Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some code that works fine, unless I have followed a hyperlink first.
I have built a form which all works correctly, and I have now added an image which triggers a hyperlink in its click-event. (ActiveWorkbook.FollowHyperlink Address:="http://www.myAddressHere.co.uk", NewWindow:=True) If I use the hyperlink, and then go back and try and continue using the form, then nothing works, I get an error: Method 'Range' of object '_Global' failed it stops on this line Set xRange = Range(rngRange) where rngRange is a RefEdit control with a valid range reference in it - it works fine if I haven't clicked the hyperlink first. I could lose the hyperlink, but I'd really like to get to the bottom of this. Any ideas? Thanks Michelle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need some Help with FollowHyperlink please (Error 432) | Excel Programming | |||
FollowHyperlink failing | Excel Programming | |||
FollowHyperlink to OLEObject | Excel Programming | |||
FollowHyperlink | Excel Programming | |||
followhyperlink | Excel Programming |