Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the gurus just helped me with "select".
you can measurably shorten your code by using Sheets("Production").Range("D4").ClearContents (one line instead of three). OR With Sheets("Production") .Range("D4").ClearContents .Range("F4").ClearContents 'continue End With With xxxxxNextSheet End With as for why your button isn't working, where is the button located? toolbar? activex control? userform? susan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
Run-time error 1004 - General ODBC Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Run time error '1004': Generaol ODBC error | Excel Programming |