| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Loop and Read the Cell until the end of worksheet
Dear all,
Suppose I have three columns of Data. Now I want to read the first column and third column. How can I write VBA code to loop the first column and third column till the end of the worksheet.? Here are my questions: How to determine there is an end in worksheet? How to loop the first column and third column cell by cell. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Loop and Read the Cell until the end of worksheet
One way
For Each cell In Range("A1").CurrentRegion If cell.Column = 1 Or cell.Column = 3 Then 'do stuff End If Next cell -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "hon123456" wrote in message ups.com... Dear all, Suppose I have three columns of Data. Now I want to read the first column and third column. How can I write VBA code to loop the first column and third column till the end of the worksheet.? Here are my questions: How to determine there is an end in worksheet? How to loop the first column and third column cell by cell. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| read and check cells in loop | Excel Programming | |||
| Worksheet loop won't loop | Excel Programming | |||
| having probelms getting my loop to terminate on an array value read from an empty cell | Excel Programming | |||
| "read only" cell in a given worksheet | Excel Discussion (Misc queries) | |||
| How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
Linear Mode
