Compile Error. Sub of Function not Defined.

Hi, Im really new to VBA Macro and i would appreciate all the help I can get from anyone.
I have a range of amounts in Sheet 1 from F7:Q13 and im using the find method to search for the active and non active values in the cell. Which means that if there's a value in the cell it will transfer the value in Sheet 2, if nothing is found in the cell the cells in Sheet 2 will return as nothing or null.

I think the problem lies on the FindWhat variable. Im getting a compiled error which im not sure what is it.

I've attached the spreadsheet so you get a better idea of the problem that i encountered. Thanks soo much in advance!

Please Login or Register  to view this content.

Hi

You don't have any code for the function FindAll in this workbook. What is the code for this function?

rylo

Try http://www.cpearson.com/excel/RangeFind.htm It has all the function examples for what you are doing.

Thanks for the replies.

I've read the link that you attached but im still confuse as to how i can find the values in the cells. Im trying to use the Dim Array now but there's still error. Can you help me check the codes cos i don't know where have i gone wrong.

Please Login or Register  to view this content.

I've changed the code but the problem still lies on this line

Please Login or Register  to view this content.

Thanks for your time, really.

So are you suggesting that the variable MyArray should be removed since the loop through FoundCells is redundant?

Hi again I adjusted the codes to find the range of data with active cells but when doing so, a run time error occur. (in red font) Are there anyone willing to help.?

Please Login or Register  to view this content.

It's alright romperstomper, I re-edited the entire code. I really appreciate your help especially when you solved the previous problem that I encountered. Thanks alot!! I'll post up more queries if I encounter any. Thanks again!=)