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!
-
Excel: vlookup and sorted data
Hi, I'm calling the vlookup function from VBA code, but I only get the correct values when the table is sorted. Is this right? I thought the vlookup function could look up unsorted tables for exact matches - indeed, if I use the vlookup as a formula in a worksheet cell it returns the correct...- Malachy
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
.Name property in event Worksheet_SelectionChange
Hi Mike, Thank you that was very helpful - I thought it must be something quite straight forward. You live, you learn! Thanks for the tip on error trapping - it's high time my code included some of that. M.- Malachy
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
.Name property in event Worksheet_SelectionChange
Hello, I'm trying to pass the Range Name of the active cell every time the Worksheet_SelectionChange event is called. This code doesn't work... Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim rangeString As String rangeString = ActiveCell.name Call...- Malachy
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
