This value must be a scalar

[TR_9781963]

I have used units but when writing the function to excel I am getting error. Please help 

[Raiko]

hi,

WRITEEXCEL can't do units. See excerpt from mathcad help.

I suggest to divide the matrix you'd like to export with "UnitsOf(variable)" before writing to Excel.

Regards

Raiko

[Werner_E]

The problem is not WRITEEXCEL as you correctly strip the units when you use it.

The problem is that B1 is a range, not a vector, and so it can't be used as the argument for function A,tR.

Find attached two ways to deal with that situation.

[Raiko]

You're right. I didn't notice it.

[Werner_E]

It doesn't matter anyway. If you look at all the questions this user already had posted it seems, that he isn't really interested in the answers - at least he seems to think that it isn't necessary to come back, close the threads and maybe comment the answers given.

[terryhendicott · Accepted solution]

Hi

Here is the file working.

The problem is B1 is defined in your sheet as a range variable. 

Looks in PTC Prime exactly like a vector.

To change it to a vector just use the hack of putting an equal sign after it to show it.