vba program doesn't work

vba program doesn't work

Hi,

I' ve written a program in vba but there's an error while I'm running it:

"Encountered error at line 18 :com.adventnet.zoho.websheet.model.util.DataRange cannot be cast to com.tripi.asp.JavaObjectNode"

what does exactly mean?

my line 18 is:
Do While Sheet2.Cells(2, kolumna_dzien) <> ""

the same programs works well in excel :(

thank's in advance for help.

(it's a pity that there's no ability to get into program in "step by step" mode (F8 in excel vba editor) with locals window)


p.s. all sheet users are waiting for conditional formatting :)