Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining Range of For Each Loop for Cells and Worksheets
I often use:
For Each Cell in Worksheet.UsedRange My understanding is that you cannot alter the UsedRange property as it is read only. Is it possible to define a range up front and use this in conjuction with a For Each Loop using Cell and Worksheet. Best case scenario my goal would be to either use this range to limit the area covered by the For Each loop. Or worse case scenario use it to limit the actions undertakeh within the loop Dim NewRange as Range For Each Cell in Worksheet.Something???? Next Or Dim NewRange as Range 'Note NewRange would be a subst of .UsedRange For Each Cell in Worksheet.UsedRange If Cell.Address is within NewRange Then do something Next |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining Range of For Each Loop for Cells and Worksheets
In the context that you show, you are reading it!
-- HTH RP (remove nothere from the email address if mailing direct) "ExcelMonkey" wrote in message ... I often use: For Each Cell in Worksheet.UsedRange My understanding is that you cannot alter the UsedRange property as it is read only. Is it possible to define a range up front and use this in conjuction with a For Each Loop using Cell and Worksheet. Best case scenario my goal would be to either use this range to limit the area covered by the For Each loop. Or worse case scenario use it to limit the actions undertakeh within the loop Dim NewRange as Range For Each Cell in Worksheet.Something???? Next Or Dim NewRange as Range 'Note NewRange would be a subst of .UsedRange For Each Cell in Worksheet.UsedRange If Cell.Address is within NewRange Then do something Next |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining Range of For Each Loop for Cells and Worksheets
if your data is like a database, perhaps
for each cell in Activesheet.Range("A1").CurrentRegion Next cell As a Test: click in cell A1. Do Ctrl+Shift+8 does this select all the data you want to process? If so, that is the current region. -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... I often use: For Each Cell in Worksheet.UsedRange My understanding is that you cannot alter the UsedRange property as it is read only. Is it possible to define a range up front and use this in conjuction with a For Each Loop using Cell and Worksheet. Best case scenario my goal would be to either use this range to limit the area covered by the For Each loop. Or worse case scenario use it to limit the actions undertakeh within the loop Dim NewRange as Range For Each Cell in Worksheet.Something???? Next Or Dim NewRange as Range 'Note NewRange would be a subst of .UsedRange For Each Cell in Worksheet.UsedRange If Cell.Address is within NewRange Then do something Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining a custom-named Range across several worksheets | Excel Worksheet Functions | |||
defining unique range of cells for different sheets as the same n. | Excel Discussion (Misc queries) | |||
Drop down defining content of a range of cells | Links and Linking in Excel | |||
Defining a variable Range for cells with values in them! | Excel Programming | |||
Error 1004 when defining range by cells(r,c) format | Excel Programming |