Hello,

I am trying to use the function IsEmpty with cells().Something like:

public sub test()
for i=1 to 11
if Isempty(sheet1.cells(i,1))=true then
imax=i-1
endif
next i
end test

It does not work.

Please advise

Thank you