| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable not Defined Compile error
Hello, This code triggers a compile error, variable not defined.
Sheet2 is the culprit, how can I correct this? Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.DisplayAlerts = False Sheet2.Range("B2:I2") = Sheet1.UsedRange.Address Application.DisplayAlerts = True End Sub Thanks in advance for any help. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile error, Variable not defined | Excel Programming | |||
| VBAProject name compile error, not defined at compile time | Excel Programming | |||
| Incremental Numbering: Compile Error - Variable not defined | Excel Programming | |||
| Variable not defined compile error | Excel Programming | |||
| Compile error, variable not defined | Excel Programming | |||
Threaded Mode
