Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I want to search a "block" of cells this code will search across columns
then by rows, is there anyway to search all of the rows in a column before moving to the next row? In other words colum A rows1 1-10, col B rows 1-10...etc instead of A1, B1, C1, A2, B2, C2 Thanks Function jjj() Dim terry As Range Set terry = Worksheets(1).Range("A1:C3") For Each x In terry MsgBox x.Value Next x End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
returning pivottable object from a range object | Excel Programming | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |