|
|
#10
02-05-2016, 10:06 AM
|
|||
|
|||
mmpCal
I changed all the named ranges (d, date, hrs, initials) so that last row is 1000 instead of 13 and it works fine for me.
As mentioned a couple of times before don't change the references to whole columns! That's a sure way to kill Excel when you have array- or array-like formulas. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Setting autofilter criteria using columns and cells relative to the active cell in another sheet
|
SarahL | Excel Programming | 7 | 06-11-2015 10:26 AM |
| Populating Data in New TABs? | Sueade | Excel | 2 | 06-02-2015 09:12 PM |
|
Delete blank rows between the two rows that contain data
|
beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
|
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.
|
rogcar75 | Excel | 3 | 08-28-2014 05:21 PM |
| Fix data output position relative to page | Al See | Mail Merge | 1 | 01-16-2014 04:13 PM |
Windows 10 
Office 2013
Threaded Mode