Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expanding ranges causing probs?
I have named ranges from rows D2 - X30, D31 - X50 and D51 - X80 (name first, second and third) at the bottom of these (from A80 downward) have some formatted rows that can have data entered, when the AutoClos runs it sorts all the rows by date (the dates for all ranges appear i column A) but when a row is taken from the extra area (below A80) an sorted in date order and inserted into one of the named ranges (let say FIRST) then the range expands but moves the other ranges out (i. FIRST would now be D2 - X31 and SECOND would be D32 - X51) and this i causing problems with calulations that are taken from these cells, I there anyway to cure this problem? The sorted inserted rows will always go in between 2 dates as the ranges are sections of the year. Any thoughts or help will be greatfully recieved. Thanks, Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=49733 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding ranges in macros | Excel Discussion (Misc queries) | |||
Named ranges are causing a #REF error | Excel Discussion (Misc queries) | |||
Using Query and expanding named ranges | Excel Discussion (Misc queries) | |||
Expanding ranges after sort??? | Excel Programming | |||
Items in disabled items list - unknown excel addins causing probs | Excel Programming |