Going through each item in a sheet

  • Thread starter Thread starter ajitpalsingh200
  • Start date Start date
A

ajitpalsingh200

Thankx you very much magesh..But i hv one more ques here..

How do it get the number of items in the list..

For example lets say Cell A have 20 items...How do i write a code t
find out the number of items in cell A

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

NosOfItems gives the required number

- Manges
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting items in an array 6
I need ONLY subtotals copied to a second sheet 4
Item rows into order sheet 2
Going through each item in a sheet 2
list box remove item by combobox 4
List of items from other sheets 2
Copy fixed range of multiple sheets into new workbook 9
Excel Changing amounts from one sheet to another using specific item # 7

Back
Top