Thu 31 Oct 2019

Excel Quiz 59 - Date & Time Quiz

By |Thursday, October 31st, 2019|Categories: Quizzes|Tags: , , , , , |0 Comments

A general quiz on Excel

Tue 15 Oct 2019

Tips & Tricks 173 - VBA - OR Condition in FIND

By |Tuesday, October 15th, 2019|Categories: Tips and Tricks, VBA|Tags: , , , |0 Comments

FIND is a very powerful function in VBA but it doesn't support OR condition. Hence, if you want to find say two values "A" or "B", then you can code an array within FIND. To do OR in FIND, you will need to use following code (this is a sample code only, there can be many variations of this code) (more…)