|
|
#7
03-18-2020, 07:13 AM
|
|||
|
|||
Marcia,
You might want to look at the link again that NoSparks posted. You End the case statement therefore the following line does not know what ws is. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 9 | 07-27-2018 02:06 AM |
 Table with values from several locations and years - need to find comp values
|
Ricardo Sousa | Excel | 6 | 06-09-2018 10:51 PM |
| Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
| How to Hide/Un-hide a worksheet based on cell on another sheet. | easton11 | Excel Programming | 1 | 06-02-2015 12:07 PM |
Windows 10 
Office 2016
Threaded Mode