Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Use a loop to hide rows
I'm sure this is a simple matter, but I am struggling with it. Basically, I want the program to loop through a single column, like this (Pseudo code): dim count as integer count = 1 do until EOD if hcount = "" select whole row hide whole row end if increment count loop End program. Any...- pawnman
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Conditional sums in Excel
I'm pretty new to VBA, so here's my question: I have an Excel worksheet with 8 columns of data. I need to sum every few rows in a single column, based on a different column (It's figuring out the number of bills in deposits for a bank, so I need to sum only the columns that are bills while...- pawnman
- Thread
- Replies: 15
- Forum: VBA Visual Basic for Applications (Microsoft)
-
"Next 20"-style perl script for a database
Here's the deal. We have a perl script that queries a database. We can pull individual records, people who have paid, etc. What we want is a way to access ALL the records, twenty at a time, using little "next 20" and "last 20" links like on a search engine. Right now...
