| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code error
I had code which worked great under Excel 2003 but not working under Excel
2007. I get the following error Method 'Union" of object '_Global' failed with the code below If Union(Target, Range("B5:B6")).Address = Range("B5:B6").Address Then SortModule.PTOSort |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code error
If Target.Address="$B$5:$B$6" Then
SortModule.PTOSort -- Gary''s Student - gsnu200812 "ordnance1" wrote: I had code which worked great under Excel 2003 but not working under Excel 2007. I get the following error Method 'Union" of object '_Global' failed with the code below If Union(Target, Range("B5:B6")).Address = Range("B5:B6").Address Then SortModule.PTOSort |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| OnTime code error "can't execute code in break mode" | Excel Programming | |||
| Error in Excel VBA Code (Error 91) | Excel Programming | |||
| How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
| Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Linear Mode
