Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
Copy rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
macro to copy multiple rows to separate worksheets | Excel Worksheet Functions |