Stephanie Lim
Active Member
Joined: Jul 4, 2018
Follow
RE: How to generate whole table of values using code for VLookUp?
Hi Sunny, That works. Thank you!
7 years ago
Forum
RE: How to generate whole table of values using code for VLookUp?
Hi Sunny, Pls refer to this sample worksheet. Basically, when I click on the button 'Identify Product Type' in the 'Data' tab, I want to identif...
7 years ago
Forum
Forum
Replies: 4
Views: 102
RE: How to Apply Conditional Formatting on a Variably Sized Range VBA
Hi Sunny, Yes it works, thanks! Can I understand why it won't work with my original code though (for learning purposes)? Why can't I assign Unio...
7 years ago
Forum
RE: How to Apply Conditional Formatting on a Variably Sized Range VBA
Hi Sunny, Attached is the sample data. Basically what I'm trying to do is to compare the account codes in Cols A and E and see which account/val...
7 years ago
Forum
Forum
Replies: 5
Views: 57