if then else statement not working

hi


i have done this statement it copies a range to 3 sheets ,i have put a if then else statement , if yes is on row q3 then only copy rows = to yes
but now the first statement will not work now,could someone give me some guidance please,have read and downloaded lots of samples,just stuck now
cheers colin

Please Login or Register  to view this content.

Hi, colin,

maybe just set a With-Statement with the sheet name and refer to that? If nothing is indicated ranges refer to the active sheet.

Please Login or Register  to view this content.

Why not apply an Autofilter to narrow down the number of cells to be checked?

Ciao,
Holger