VBA – Instr

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The InStr Function returns the first occurrence of one string within another string. The search happens from the left to the right. Syntax InStr([start,]string1,string2[,compare]) Parameter Description Start − An optional parameter.…

Continue ReadingVBA – Instr

VBA – Exit Do

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

An Exit Do Statement is used when we want to exit the Do Loops based on certain criteria. It can be used within both Do…While and Do...Until Loops. When Exit Do is executed, the control jumps to the next statement…

Continue ReadingVBA – Exit Do