How to Paste VBA code properly...

**TLiles** · 06-03-2010, 12:00 PM

I've found what I'm looking for on this site...

http://hairyears.livejournal.com/115...l#VFuzzyLookup

the code should be exactly what I want, so I copied and pasted it into a VBA module (the extent of my VBA abilities FYI) and am hoping to see the new functions from the code show up in my worksheet.

It's not... what am I doing wrong?

**royUK** · 06-03-2010, 12:03 PM

Have you inserted a new module in the VB Editor?

Maybe you should attach the workbook that you have used

**TLiles** · 06-03-2010, 12:08 PM

yes, I went into VBA and inserted a new module and copied from....

Please Login or Register  to view this content.

did I do that correctly?

If I did... how do I find the function in excel? Search like a normal function?

**TLiles** · 06-03-2010, 12:13 PM

figured it out! it's in 'user defined' when i look it up in the functions...

sorry, never done this before!!

**royUK** · 06-03-2010, 12:34 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here