View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Niklas[_3_] Niklas[_3_] is offline
external usenet poster
 
Posts: 13
Default Find last used cell in an column

Hi
What is the best way of finding the last used cell in a
column?
At the moment i use:

While Len(i_workSheet.Range(i_sColumn & CStr
(i_iIndex)).value) 0
i_iIndex = i_iIndex + 1
Wend

GetLastUsedRowInColumn = i_iIndex

Yours sincerly
/Niklas