View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Another Question Concerning Replacing Formulae With Values !

Donna,

missed your earlier answers. If you do not reply directly to a post
the poster is not notified.

I understand from Dave that BreakLink requires excel XP, which
you apparently do not have and I forgot to check which version it was
available.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

Dave,
As promised it errors on the Resume Next with...
Runtime Error 20
Resume Without Error

......KeepITcool.....As I've said I have tried the .BreakLinks but can
not get it to work without it erroring but as I can not find any help
attached to 'BreakLinks' (even the object browser won't recognise it)
I can not follow this up yet. In my earlier post I asked if it may be
part of a libarary that I have not got referenced. Object browser
finds LinkSources but not BreakLinks. The error message that pops up
with 'BreakLinks' is....
Runtime Error 438
Object doesn't support this property or method