wrong result of worksheetFunction.countif

[mohan.r1980]

Hi experts,

i am doing a macro where i want to restrict double file entry while extraction.

i set the the "Log" sheet name where i write all the filename in B column.

Start of the macro i have check the filename in sheets("Log") is exists or not

this is the code i have set

Please Login or Register  to view this content.

if i run macro for first time of Feb Month then it shows me correct result because Log sheet have no filename.
but if i run second time of same Month (Feb) then it also run but output is totally blank.
i checked the count of running file in msgbox then it show me 0 value but same file is exist in Log Sheet

how this happening?
Please suggest me

[Kaper]

But what is the value of sfilename. May be problem is here?

Please Login or Register  to view this content.

[mohan.r1980]

Hi Kaper,

thanks for reply
sFilename have no problem.
because same filename i have write on first time run
so when i run second time it should be 1 or more but it show me 0 so my code take all the steps which i set to ignore.

[Kaper]

Anyway, I'd expect problem with it. May be sfilename has a name and path, and you write just name? Or oposite? May be value of this variable has changed or is set out of the scope of your current procedure?

BTW: have you tried my simple code? Or just answeered "no, I'm sure it's not the case" - sorry for asking, but it's quite common attitude on forums.

May be there are merged cells? And may be you do not write your values to column B indeed.

Last suggestipn is (as almost always): attach sample file.

[mohan.r1980]

thanks Kaper,

yes i tried all the way (may be some silly mistake still left ) but my result is same. any way i will do it some another way

thanks again Kaper