|
|
#4
03-28-2015, 12:06 PM
|
|||
|
|||
Hi,
If the code failed you may need to "Reset" it. The problem with worksheet function is there are a pain to use. In the same module try this code to reset the worksheet event. Code:
Sub Reset_worksheet Application.EnableEvents = True end sub Last edited by charlesdh; 03-28-2015 at 12:10 PM. Reason: Brain faster than writing...corrected info 
|
| Tags |
| macro |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Read cell from one table into another
|
donaldadams1951 | Word VBA | 2 | 02-04-2015 06:46 PM |
| Macro to copy formula from one cell to another | anwar | Excel Programming | 1 | 04-25-2014 08:27 PM |
|
Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| how to read R1C1 formula | Suhanti | Excel | 2 | 10-16-2010 11:30 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode