Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Process multiple rows
Hello all,
Just wondering if there is someone out there that might have run into this problem before and would be willing to point me in the correct direction. I am attempting to create a macro that will process information based on the row (s) that the user selects. I am attmpting to allow the used to select any row(s) that he or she might want but am having trouble in determining what has been selected. I would like to allow the user to select any cell(s) on any row(s) and only process the information on those rows. An example of this would be a user could select A1, B3, F3 and all of row 100. From this I would want to process row 1, 3 (but only once even though it was selected twice) and 100. From a little research I think that I can read row numbers into and access them from an array variable in a manner of ARRAY_NAME(counter) = Row_Number - Is this correct as well? Any help that anyone would be willing to offer would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Process multiple rows
hi, Terry !
here is one (possible) approach: Sub A() Dim myCell As Range For Each myCell In Intersect(Range("a:a"), Selection.EntireRow) MsgBox "Processing row: " & myCell.Row Next End Sub hth, hector. __ OP __ Just wondering if there is someone out there that might have run into this problem before and would be willing to point me in the correct direction. I am attempting to create a macro that will process information based on the row (s) that the user selects. I am attmpting to allow the used to select any row(s) that he or she might want but am having trouble in determining what has been selected. I would like to allow the user to select any cell(s) on any row(s) and only process the information on those rows. An example of this would be a user could select A1, B3, F3 and all of row 100. From this I would want to process row 1, 3 (but only once even though it was selected twice) and 100. From a little research I think that I can read row numbers into and access them from an array variable in a manner of ARRAY_NAME(counter) = Row_Number - Is this correct as well? Any help that anyone would be willing to offer would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the process of displaying a subset of rows in a table means? | Excel Discussion (Misc queries) | |||
How to process multiple Excel Files | Excel Programming | |||
Excel 2003: VBA - Hide Rows process now too slow | Excel Programming | |||
How to process selected rows | Excel Programming | |||
macro to process rows in a selection | Excel Programming |