View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Goto next empty cell in a range

try

Sub findnextblank()
Application.Goto [findrng].Find("", after:=ActiveCell)
End Sub

--
Don Guillett
SalesAid Software

"Keith Robinson" wrote in message
...
Can any one help me with a macro/code that will make the
next empty cell in a named rage become the active cell