Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cylecle all cells in worksheet

Status
Not open for further replies.
bont

bont

Programmer
Sep 7, 2000
200
US
How can I cycle through a range of cells, where the range of cells is the entire worksheet not matter if only column is used or if every possible column and row is used?
 
Sort by date Sort by votes
Use
Code: 
    Dim c As Range
    For Each c In Worksheets("Sheet1").Cells
        'Procees
    Next

There are 16,777,216 cells in each worksheet, so depending on what action you are performing it may be slow.

A.C
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EliseFreedman
  • Locked
  • Question
booking tool - all day time slots
Replies
3
Views
249
Andrzejek
Andrzejek
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
163
sal21
sal21
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
186
mintjulep
M
kapok1
  • Locked
  • Question
add all the files under the same folder including the subfolder, all sheets in worbook included
Replies
2
Views
130
kapok1
kapok1
lameid
  • Locked
  • Question
Correct Outlook Event to process all messages?
Replies
3
Views
253
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top