View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter Chatterton[_4_] Peter Chatterton[_4_] is offline
external usenet poster
 
Posts: 20
Default How do I get a Function to return Null?

Thanks Tom.

Peter


"Tom Ogilvy" wrote in message
...
Public Function getNextRow() As Range
...
Set getNextRow = Nothing
...
End Function

--
Regards,
Tom Ogilvy


"Peter Chatterton" wrote in message
...
The following code gives:
Runtime error 424, Object Required

Public Function getNextRow() As Range
...
Set getNextRow = Null
...
End Function

Thanks,
Peter