View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default Help to improve UDF please

Hi Peter,

I have done some 'Googling' and the 'count' method will return
undesirable results in earlier versions of XL. It seems that it is
pretty much impossible to determine the real last cell (ie that
contains data) without going through the process of deleting unwanted
columns & rows and saving the file.

I think l will have to live with what l have got so far and resort to
the tried and tested methods if l have to develop anything on XL97
2000

Regards

Michael