JulianJaimes1985
New Member
- Joined
- Feb 18, 2022
- Messages
- 4
- Office Version
- 2021
- Platform
- Windows
Hi all,
I am in need to write a custom function where i would be using the Worksheetfunction.convert(). Inside the arguments for the function the first argument (number or amount to convert) is a variable inside the function. I have typed the function like this but it has not worked: Worksheetfunction.convert(X, "m", "ft"). I have tried changing the X for a number e.g. 10 and it works but no when i use the variable name.
Does anyone know how to fix this? Thanks for your help.
Regards
I am in need to write a custom function where i would be using the Worksheetfunction.convert(). Inside the arguments for the function the first argument (number or amount to convert) is a variable inside the function. I have typed the function like this but it has not worked: Worksheetfunction.convert(X, "m", "ft"). I have tried changing the X for a number e.g. 10 and it works but no when i use the variable name.
Does anyone know how to fix this? Thanks for your help.
Regards