View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IgorM[_2_] IgorM[_2_] is offline
external usenet poster
 
Posts: 41
Default Runtime error 1004

Hi

When my macro tries to run the line below if the selected cell has no
formulas i get a runtime error 1004 - no cells were found. How to get around
this?

Selection.DirectPrecedents.Select

Kind regards
Igor