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

For i = 1 To Range(Range("A1"), Selection.End(xlDown)).Count
MsgBox Cells(i, 1)
Next


- 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