FindAll in VBA

Hi

Googled but saw "Find Next"
VBA does not have direct function to return array of cell addresses with a single line of code?

Can it be returned without using FindNext

Originally Posted by ImranBhatti

VBA does not have direct function to return array of cell addresses with a single line of code?

No.

Can it be returned without using FindNext

Yes - by using the same Find repeatedly.