I know how to process multiple selections of cells, using "For Each rCell in Selection" processing. Is there a similar way to process each entire row or column selected, without having to manually loop thru thousands or millions of individual cells?
Working with multiple selected rows or columns
-
-
-
Re: Working with multiple selected rows or columns
Depends on what exactly you want to do... For example, you can do search/replace on an entire row/column without having to search each cell. You can use most mathematical functions on entire rows/columns.
Ger
-
Re: Working with multiple selected rows or columns
What I want to do is to allow the selection of multiple rows, and then do a "For Each..." type function so I can do my processing for each row individually. It's not a search/replace or anything like that -- my procedure processes certain cells in columns within each row for special purposes.
I could do a standard "For Each cell in Selection" and only process when I hit column 1 in each row, but that means cycling thru 16k+ cells of cells to get each row, and over a million cells if they erroneously select a column (my procedure will need to check for this).
-
Re: Working with multiple selected rows or columns
I found the solution to my problem and it's simple. Just use "Find rcells in Selection.Rows" and it loops by row, setting rcell to the range for the row! Easy if you know how to do it....
-
Re: Working with multiple selected rows or columns
Thanks for posting back your solution!
Cheers,
Ger -
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!