if then else statement not working

[cfinch100]

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.

[HaHoBe]

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

[cfinch100]

hi
thanks for the code but it did not do anything im afraid, have you any other ideas please
cheers colin

[cfinch100]

hi
have just found this code works well, just screen flickers alot is there any way to stop this
cheers colin

Please Login or Register  to view this content.