ExcelBanter - Going through each item in a sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Going through each item in a sheet (https://www.excelbanter.com/excel-programming/315977-re-going-through-each-item-sheet.html)

mangesh_yadav[_171_]

Going through each item in a sheet

nos = Range(Selection, Selection.End(xlDown)).Count

ReDim a(0 To nos)

- 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:09 PM.