On Thu, 10 Feb 2005 08:19:28 -0800, "Ken"
wrote:
Ron ... (Good morning)
Thanks ... working great ... I have 3 TabSheets ... Your
way produced same results on 2 or 3 ... I am checking the
3rd one as my test file is coming up with same value as
your Function ...
Next ... Can I rename this Function to something easier
for me to remember ...
From ... =lvt8v($as$2:$as$5000)
To ... = ??????($as$2:$as$5000)
Thanks Ron ... I may get there from here ... Kha
I glad it's working.
To change the name of the function, you merely change all instance of the
current name to whatever you want.
I would use the Edit function.
For example, to change the UDF name to Foo:
With your module open, in the VBEditor Main Menu Bar select
Edit/Replace
Find What: lvt8v
Replace With: Foo
Search Current Module
Replace All
--ron
|