Going through each item in a sheet
Oh okk Mangesh, the spereadsheet im working with have a few sheets in it...Ho to tell that particular code to count the items in the "results" sheet -- ajitpalsingh20 ----------------------------------------------------------------------- ajitpalsingh200's Profile: http://www.excelforum.com/member.php...fo&userid=1615 View this thread: http://www.excelforum.com/showthread.php?threadid=27586 |
Going through each item in a sheet
Worksheets("Result").Range("A1").Select For i = 1 To Range(Selection, Selection.End(xlDown)).Count MsgBox Cells(i, 1) Next this should work or Simply Worksheets("Result").Select Range("A1").Select For i = 1 To Range(Selection, 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 |
All times are GMT +1. The time now is 11:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com