Windows 10: Evaluate function

Pulling data from Google docs.

Column A2 visually has number 360 but the address of the cell is something like this: =IFERROR(__xludf.DUMMYFUNCTION("""COMPUTED_VALUE"""),"360")


If I go to B2 and enter the formula =VALUE(A2) I get a number 360 which is actually a sting value.


My question is, when I use the following:

myvar=Evaluate(worksheets("test").Cells(2,1)

I get error "Type mismatch"


What is the workaround here. Excel 10 on Windows 10.

Thanks.

:)

 

WINDOWS 10 ENTERPRISE EVALUATION

Hi Raju,

We need the following information for us to be able understand your concern:

• How did you get the Windows 10 Enterprise Evaluation?
• Are you the one who installed the Windows 10 Enterprise Evaluation or is already installed on your laptop?
  
• If you're the one who installed the Windows 10 Enterprise Evaluation, how did you install it?
• Are you using the Windows 10 Enterprise Evaluation for home use or are you on a business environment?
• If you're on a business environment, are you one of the IT administrator on your company?

We'll be waiting to your response.

 

alt-key functionality

Hi Steven,

Thank you for posting your query on Microsoft Community.

I suggest you to follow the steps below and check if it helps:

• Single Click on the file.
• Tap F2 ( Function Key).
• Then type the name and enter.

Hope this answers your query and do let us know if you need further assistance. We will be glad to assist.

 

Additional Image Upload Functionality

I know. That's why I was suggesting more functionality. :/