> > >

Excel MCQs

One of the major differences between the inStr function in VBA and the Excel Search function is that...

Search can never be called in a VBA module, while inStr can.

inStr returns 0 if the value is not found, while the Search function produces an error.

inStr will not search a whole string, while Search always searches a whole string.

inStr value can never be printed to a cell, while the Search function always prints to a cell.

Answer

Correct Answer: inStr returns 0 if the value is not found, while the Search function produces an error.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it