|
|
#3
03-28-2012, 05:14 AM
|
||||
|
||||
Instead of using full columns for your defined ranges maybe you could use Dynamic ranges
Fi the range named "department". instead of defining the range as "D: D""( which is very long) try Code:
=$D$2:INDEX($D:$D,COUNTA($D:$D))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Color Worksheet Tabs | avie layne | Excel | 4 | 11-12-2012 04:45 PM |
| Distortion trying to embed excel worksheet | Sugaratias | Word | 0 | 11-26-2011 11:26 AM |
| Embedded Excel in Word very slow to update | delaneybob | Word | 0 | 02-11-2011 10:03 AM |
 VB Code in Excel Active worksheet
|
shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |
| PowerPoint Master - 50 LINKED slides - SLOW Update | salfonsi | PowerPoint | 0 | 09-27-2008 02:55 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode