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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sorting In Excel
This little sub will tell you how many rows you have with something in them: Sub GetRows() Dim C As Range Worksheets(1).Activate [F10:F10010].Select For Each C In Selection.Cells If C.Value <> "" Then Counter = Counter + 1 End If Next C...- kruskovac
- Post #5
- Forum: Microsoft: Office
-
Sorting In Excel
I do this in two steps--one to find the number of rows, dynamically and the next to actually do the sorting on the range selected. Here's the subroutine to find the number of rows on a worksheet: Sub GetRows() Dim C As Range Worksheets(1).Activate [F10:F10010].Select For Each C...- kruskovac
- Post #4
- Forum: Microsoft: Office
-
Application exception error in Excel 97
if possible, send one to me also at: kruskovac@crown.net- kruskovac
- Post #6
- Forum: Microsoft: Office
-
Automation Problems
I agree with dreamboat, you should be able to call the function from the open event of the workbook when it first opens- kruskovac
- Post #3
- Forum: Microsoft: Office
-
Transferring Outlook 2000 contacts to another drive and outlook progra
Aren't the contacts part of the outlook.pst file?- kruskovac
- Post #2
- Forum: Microsoft: Office
