Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use UsedRange.SpeciaCells() to loop through all Cells?
I know I can use the .UsedRange property to loop through cells. I also know
I can use the UsedRange.SpecialCells() property to further define this. Is it possible to use the SpecialCells() property and have it run as if you only wanted the UsedRange by itself. This loops through cells with formulas. Thisworkbook.Worksheets("Sheet1").UsedRange.Specia lCells(xlformulas) I want to continue to use this script but have the variable in brackets after .SpecialCells mean all cells. Thisworkbook.Worksheets("Sheet1").UsedRange.Specia lCells(something else) I want to do this to avoid using two separate loops. I want one loop, and then I want to pass a variable to the brackets after SpecialCells. Make sense? EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear UsedRange except specific cells? | Excel Programming | |||
USEDRANGE | Excel Programming | |||
Help - loop through cells in a range that are not together (several different cells as Target) | Excel Programming | |||
UsedRange & Formatting of Cells | Excel Programming | |||
Using UsedRange as limits in a For Each loop but for cells on another sheet ? | Excel Programming |