-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
variable row count
-
L
Variable Rows, Help Speeding Up
Hello, I have the below piece of code that runs, but is extremely slow. I know the problem is the fact that it is looping through all 75000 rows. What I needs is, how do I change the code to just check the rows that actually have data in them? This is only a part of the overall code, I did...- Lelewiwi
- Thread
- fast code variable row count vba
- Replies: 4
- Forum: Excel Questions
-
J
VBA Select Active Cells in Column
I have a report that has a variable number of rows, depending on the number of transactions returned. I need to select the active cells in Col. "L", but exclude the last active cell, because it contains the Total for that column. The data to select in column "L" starts on row 5. Once I get...- jerryneubauer
- Thread
- active cells select variable row count vba
- Replies: 3
- Forum: Excel Questions
-
F
switching rows to columns and removing multiples with variable row count
Hello, I would love o get some help with this problem, since it was quite some time i used excel for more than summing things up. So - I've got a table with about 1000 rows, and four columns. The first column has the ID of a place. The second column has the name of that place The second...- fiscot
- Thread
- multiple row switch row/column variable row count
- Replies: 3
- Forum: Excel Questions
