Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i need to place a criteria to enable the macro from stop its execution
if J324=0, then end ---- Sub filldown() Do If Range("J324").Formula 0 Then Range("J324").Copy Range("C88").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E225:E263").Copy Range("l8500").End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True End If Loop End Sub ----- regards, driller |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Escape key won't work | Excel Discussion (Misc queries) | |||
Error handling and escape key | Excel Programming | |||
escape character | Excel Programming | |||
using escape key to exit a userform | Excel Programming | |||
How to escape this error message | Excel Programming |