View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skeletor Skeletor is offline
external usenet poster
 
Posts: 15
Default Copy Rows with a cell value 0 from several worksheets to a new sh

Hi, (Again).
Thanks for your help and patience by the way!

I copied it in exactly as described and it came up with a Compile error:
Block If without End If.

I added another End If at the end, closed the editor and saved the workbook.

When I typed in "1" in the quantity (F) column, nothing happened. However,in
the first row in Column A on the Job List worksheet this appeared;
"If Target.Cells.Count 1 Or IsEmpty(Target) Or ActiveSheet.Name =
(MySheet)"
"Then Exit Sub" appeared in the second row on the same page.

What am I doing wrong?
Best Wishes
Mike