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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mqhopewell
- Order by date
-
Looping through worksheet cells running same function
Hi, I have data in a cell (say A1) and say for example cells b1-e1 each have =HighorLow(A1), hence each cell runs a function passing A1 as an argument once A1 is changed. However, is there a piece of code that I can insert into this HighorLow function to see which cell is being updated (calling...- mqhopewell
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel autofilter
Hi, Using Excel, a user can turn on autofilter. This will allow a drop down box. What I want is to get the items in this drop down box (without "All", "Top 10" or "Custom". Just wondering if anyone knows how or has a piece of code to get this list? Many thanks...- mqhopewell
- Thread
- Replies: 1
- Forum: Microsoft: Office
