Going through each item in a sheet

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

ajitpalsingh200

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
 
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
 
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

Macro for all Excel Workbooks to print to PDF 2
Counting used cells on sheet 3
I need ONLY subtotals copied to a second sheet 4
Excel A CountIF question... I think 2
Going through each item in a sheet 1
Find dupes, list in MsgBox with cell.address convert ws wide code toone sheet 6
SELECTING AN ITEM FROM AUTO FILTER ! 2
hide multiple worksheets based on a formula value in one cell 1

Back
Top