"For" loop till end of column??

jonny

Professional

Reactions Received

2

Points

3,467

Posts

389
Jul 7th 2005
- #1
How to build the "for" loop that run on column, from first row till end row.
Attached the sample.

Thanks in advance.
Files

sample.xls 16.38 kB – 113 Downloads
Dave Hawley

Wizard of Oz

Reactions Received

4

Points

188,694

Posts

32,090
Jul 7th 2005
- #2
Re: "For" loop till end of column??

Hi jonny

Modify the code below to suit

Code

Sub ForEachLoop() Dim rRange As Range Dim rCell As Range Set rRange = Range("A1", Range("A65536").End(xlUp)) For Each rCell In rRange MsgBox rCell.Address Next rCell End Sub
Display More
[SIZE="2"][center]Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel [/SIZE][/center]
jonny

Professional

Reactions Received

2

Points

3,467

Posts

389
Jul 9th 2005
- #3
Re: "For" loop till end of column??

Hello, Dave.

Thank you a lot for an answer.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login

Share

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.