-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
like
-
M
VBA Lookup and like function
Hello, I'm trying to create a VBA code that looks ups a grade number and retrieves the name associated with that number, however, the current code I've written has a 'like' function that I don't quite understand and means that a student that receives a 4% will appear for lookups values 4 and...- MrsK
- Thread
- like lookup vba
- Replies: 2
- Forum: Excel Questions
-
B
VBA SQL Query ACCESS DB w/ LIKE "*" Operator
Hi Community, Looking for some help in solving a problem. I am getting back a NULL (no records it seems) when processing this query in VBA, but when i try it similarly in Acess it works the way it's supposed to. Not sure what i am doing wrong here. Any help would be appreciated. VBA SQL...- bemp87
- Thread
- like sql vba wildcard
- Replies: 5
- Forum: Excel Questions
-
A
Help with LIKE in macro please
Hi Guys, I have already had some great help on this forum, but once again I am stuck and am hoping someone can help me. I have a spreadsheet with multiple worksheet names, I want to copy some data across from e.g. the last 5 worksheet to the first 5 worksheets. The complication is that the...- Austinhead
- Thread
- like worksheet name
- Replies: 9
- Forum: Excel Questions
