Use Function from Personal.XLS in all files (loop)

[lilanngel]

Hi All,

I have a function in my Personal.XLS file that I want to use in all of the files that I am looping through. Is there any way to do this?

Basically, I have a function in Personal.XLS called "CommentOf" that gathers the text from a comment onto another cell. I want to use this function on all 400 files that I am looping through, but it looks like the function needs to be within a module in the file to be used.

Is there any way to get around that, so that I can use my function on all 400 files?

Thank you very much!!

Function CommentOf(R As range) As String
Application.Volatile
If R.Comment Is Nothing Then
CommentOf = ""
Else
CommentOf = R.Comment.Text
End If
End Function

[venkat1926]

try to create an excel addin based on a function or macro

refer to this url

http://www.fontstuff.com/vba/vbatut03.htm

[royUK]

Is the code to work on all sheets of each workbook,check every cell on each sheet? Pst the loop code so far