Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I appreciate the suggestion, and tried it, but to no avail. It stil hangs up at the same place. Besides, the name is *defined* to b "=Data!$A$8:$AX$57" (it includes the worksheet name). As a further note, I have tried drastic(?) measures such as: (1) "Help Detect and Repair..." Which took awhile, but didn' change things. (2) Testing VBA: Creating a smaller file, without the extra workshee pages and formatting, and trying a similar macro and running it. I works fine! Speaking of which, could it be "Conditional formatting" that coul affect the sort? I have one condition in the "Conditional formatting that accesses a custom VBA function--but, it works completely ok whe data is sorted in Excel itself. Still wondering what I can do! Any other suggestions -- Junio ----------------------------------------------------------------------- Junior's Profile: http://www.msusenet.com/member.php?userid=515 View this thread: http://www.msusenet.com/t-187106295 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Recorded macro | Excel Discussion (Misc queries) | |||
Problem with a recorded macro to create two pivot tables from same data | Excel Programming | |||
Problem with a recorded macro to create two pivot tables from same data | Excel Programming | |||
Problem with my Unique Number Macro...Help? | Excel Programming |