VBA gives results in active sheet (sheet1) instead of sheet2

[Akbarov]

Hey Dear community,

i have command button on sheet1, when used it should get results in sheet2 V5 but it gives results in active sheet only.

Can anybody help me please?

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

Mark "Solved" for
https://www.excelforum.com/excel-pro...ate-range.html

[Akbarov]

Thank you very much, gonna try now.

BTW how can i mark solved?

[jindon]

Like you did in


[SOLVED] Data entered from Userform Textbox shoud be in sheet2 z5

[Akbarov]

Can you please tell me how can i count if urun (A:A) is not blank?

This is not working

Cells(5, "AD") = [sum(if((isnumber(match(Musteri,market,0)))*(sifaris>0)*(urun "<>",printed))]

[kersplash]

Maybe try urun<>""

[jindon]

Is the one I posted working or not?

[Akbarov]

it is giving result on sheet2 but all results are zero :/

Please Login or Register  to view this content.

Thanks kersplash it is working