Hello 
fact: my formula is too long: over 8192..
i already converted my excel to a bin file, but still it refuses to accept my longer formula.
can i make a custom (two letter) function to replace the original function (with a long name) ?
i would like to replace hoofdletters(B1) with hl(b1) (hoofdletters is dutch for uppercase)
what would that look like? i know i need a public function ... end function in the workbook place... and what looks the function like then?
thank you !!!
Hi,
1. Maybe we can make your formula smaller. Show your formula.
2. Try to use Name_Range.
3. Cut your formula in small pieces. Depend of your version of Excel you can reduce formula.
hello
I'm already using named ranges, but i still need to fix those, because they need to adjust when rows are added...
I'm gonna try to cut the formula in two parts that will no doubt help, i still wanted to know how to make such a formula !
An Excel Function will always be more efficient than VBA.
hello
i know !!! that's why i'm asking how to make a function that converts my name to MY NAME or My Name !!!
thank you and have a great day !
Quotei know !!! that's why i'm asking how to make a function that converts my name to MY NAME or My Name
That makes no sense!
Don’t have an account yet? Register yourself now and be a part of our community!
