Revision history [back]

incorrect property value in vba macros

if cell.type = com.sun.star.table.CellContentType.TEXT and index.type= com.sun.star.table.CellContentType.TEXT then celltx = cell.text indextx = index.text if instr(1, celltx, indextx) then msgbox celltx found = found +1 end if end if

The above VBA code is giving me a incorrect property type error for the second line assignment of celltx. This does not seem to make sense. Does anyone have any ideas?

 2 No.2 Revision JohnSUN 7877 ●10 ●44 ●85

incorrect property value in vba macros

if cell.type = com.sun.star.table.CellContentType.TEXT and _
index.type= com.sun.star.table.CellContentType.TEXT then
celltx = cell.text
indextx = index.text
if instr(1, celltx, indextx) then
msgbox celltx
found = found +1
end if
end if if


The above VBA code is giving me a incorrect property type error for the second line assignment of celltx. This does not seem to make sense. Does anyone have any ideas?