Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas scrambled when sorting
I have a developed a macro that sorts a large spreadsheet by risk owner, and
then another that re-sorts it by risk number. The macro selects the whole region to be sorted and then sorts it. When I sort it by risk owner, there are two columns of formulas that are scrambled - meaning the rows in the formulas point to incorrect rows. All of the other data and formulas in columns either side of these two columns are fine - it is just the two columns that are affected. When I re-sort back by risk number, all of the formulas in those two columns are back to the correct values. Anyone have an idea as to what is going on??? Thanks for your help... Mic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting with formulas | New Users to Excel | |||
DATES ARE SCRAMBLED! | Excel Discussion (Misc queries) | |||
e mailing attatchments excel always come out as scrambled words? | Excel Worksheet Functions | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
When I import a csv file text that contained a + gets scrambled | Excel Discussion (Misc queries) |