| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moved code from worksheet to module
I had the following code in a sheet and it worked fine. I moved it to a
module and now I get object required errors. If Target.Address = "$A$3" Then Range("C4") = Range("A3") End If I tried: If Target.Address = Sheets("Sheet").Range("$A$3") Then but that dowsn't work either. How can I do this? Thanks, Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code Help - Moved from an older topic | Excel Discussion (Misc queries) | |||
| Where?Worksheet code module or Worksheet_SelectionChange event han | Excel Worksheet Functions | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| Design Best Practices: Form Control Code in Worksheet or Module | Excel Programming | |||
| Problem copying worksheet containing code module | Excel Programming | |||
Threaded Mode
