Type mismatch

[aman1234]

Hi All

I am getting Type mismatch at the following line of code. ANy help would be much appreciated.

Please Login or Register  to view this content.

Thanks

[Speshul]

Please Login or Register  to view this content.

M needs to be a number I believe,

Please Login or Register  to view this content.

(13 = the thirteenth column = Column M)

This function and others in VBA use R1C1 format, so R=ROW number, C=COLUMN number

Please Login or Register  to view this content.

Edit: Same issue with

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

ws.Cells(i, "Q").FormulaR1C1 = "=sum(" & ws.Cells(i, 26) / ws.Cells(i, 13) & ")"

[AB33]

I have run the test and did not get any error
By the way

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

But If ws.Cells(i, "M") <> 0 Then is more accurate as the column is hard coded.
I suspect the error might be found in ws

[Speshul]

I was under the impression they need to be numeric.

Now I know!

Thanks.


That being the case,

ws.Cells: What is ws declared as? Isn't a mismatch usually a result of a variable being told to be something it can't be? (assigning a string to a variable defined as a boolean, for example)

[AB33]

If you do not use Option Explicit at the top , VBA might treat ws as unknown variable and might now now show you an error. If you use Option Explicit, however,the code will error, as the object ,which in this case is worksheet, has not been defined.
You need to use "set" with object variables.