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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Process
hi, I have a problem with the excel process. I have started the excel application like this Dim oExcel As Application Dim oSheet As Worksheet Set oExcel = Excel.Application Set oBook = oExcel.Workbooks.Open(FileName) Set oSheet = oBook.ActiveSheet .... after doing some...- louisa888
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to Retrieve AutoFiltered Rows?
Hi, I got it working now. It is because I forgot to enable Autofilter. I got another question now is if it is possible to get back the specified row number? say for example, I know that row 29-39 is the autofiltered cells. I want to loop through that part to get the cell names. I at first...- louisa888
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to Retrieve AutoFiltered Rows?
Hi, Thanks for the reply. However, I've tried Set Range = Selection.SpecialCells(xlCellTypeVisible) Range.Rows.Count only equals to 1 but I'm expecting the result to be 10. What I want is that say from Excel, when I filter out the first column to a specified String, it display only the...- louisa888
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to Retrieve AutoFiltered Rows?
hi, The following is my code. oSheet.Range("A1").AutoFilter field:=1, _ Criteria1:="Application", _ VisibleDropDown:=False I'm trying to find the rows in first Column which contains the string "Application". After using the AutoFilter...- louisa888
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
