Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error message
Hi,
I have encountered a problem with the following code and am receiving this message - object variable or with block variable not set. Can someone advise?? Private Sub CommandButton1_Click() Sheets("quote2").Range("appendix").Copy Sheets("contract").Select Cells.FindNext(After:=ActiveCell).Activate Cells.Find(What:="appendix", _ After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False).Activate ActiveCell.Offset(1, 0).Select ActiveSheet.Paste End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message #N/A | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
Help with error message - please! | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |