Compile Error: compile error constant expression required.

**countryfan_nt** · 07-29-2019, 05:29 PM

Hello friends, Hope all is well!

This is a cross-post question on Mr. Excel: https://www.mrexcel.com/forum/excel-...-required.html

A solution couldn't be established, since not enough information was posted. The attachment here should show what is wrong.
Please help me correct the mistakes, to all the code to work with no errors.

Your time and efforts are always appreciated!

**Keebellah** · 07-29-2019, 05:56 PM

Since my arabic is 0% I'm guessing that the value passed as parameter is invalid.

**saudi_red_neck** · 07-30-2019, 04:25 AM

Hello friends, it seems that the VB code is OK now,
however now I am getting: #VALUE! can you please tell me what is wrong in the code?
What to do to fix it?

**Keebellah** · 07-30-2019, 04:45 AM

If you het a #VALUE error, that means that the result does NOT have the expected 'value'
I checked your file but the Function CurrText is not even addressed and you're missing all the etxra parameters.
so it won't work.
Here's the view of what CurrText expects to receive before it can process anything