I am looking for a function to compare the Activeworkbook's name to see if it has the text "Cycle" in the name. If yes return a boolean "True" and if not Boolean "False". The text "Cycle" can be passed to the function to make the function more generally useful.
I have tried my hand a bit and am failing. I copied a function I found that looked at a range of cells looking for text. But it is not working. Maybe best to start fresh?
Below is the code calling the function
Below is the function. I don't understand the use of "Byval". The code seem to die on the Dim sText as String. Again might be best to start new.
Cam
Bookmarks