Thread: Type mismatch
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Type mismatch

This is an extract from my macro:

For m = 2 To 20
.Cells(k + 2, m).Value = .Cells(k, m) - .Cells(k + 1, m)

I get a type mismatch, I think that a lot of cells in the worksheet I'm
evaluating
are words.
How do I rectify this? Help is greatly appreciated