Hi, can somebody explain the macro code for me?

[princewz]

I have a question from my work. I need to select a few cells from a huge group of numbers in excel.
I need to do this by using macro code.
And when I was learning macro, I saw a code like the figure attached with the post.
Can somebody explain it for me, please?mmexport1405218141701.jpg

[Vikas_Gautam]

I think I have understand a little bit...

The code is ... Returning a range... which start from the first cell having value "" in it.. till the last cell having value "" inside it..

the code is finding the cell containing "" each time and adds that cell to the total range using UNION function...

when "" is not found in the cell then it return the m_Return range in the result....




Don't forget to click *

[princewz]

thanks for explaining to me.
but I have a sentence which I'm really confused about it.
"Set m_cell = argRange. Find ("". m_Cell. SearchFormat: =True)"
what is this code for?
Thank you.

[princewz]

I think I have understand a little bit...

The code is ... Returning a range... which start from the first cell having value "" in it.. till the last cell having value "" inside it..

the code is finding the cell containing "" each time and adds that cell to the total range using UNION function...

when "" is not found in the cell then it return the m_Return range in the result....




Don't forget to click *

thanks for explaining to me.
but I have a sentence which I'm really confused about it.
"Set m_cell = argRange. Find ("". m_Cell. SearchFormat: =True)"
what is this code for?
Thank you.