Thread: Going through each item in a sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mangesh_yadav[_168_] mangesh_yadav[_168_] is offline
external usenet poster
  
Posts: 1
Default Going through each item in a sheet

Range("A1").Select
NosOfItems = Range(Selection, Selection.End(xlDown)).Count

NosOfItems gives the required number

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27586

Reply With QuoteReply With Quote