When trying to use the room dimensions mode calculator in this thread (post #1), I can get it to come up ok (I have the macro security set to 'medium, so I can use macros fine), and I can enter my room dimentions with no problem. But when I hit the 'Plot' button, I get the following error:
Quote:
Run Time Error '1004'
Application-defined or object-defined error
|
and hitting the 'Debug' button yields
Quote:
Selection.Sort Key1:=Range("b31"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
|
At first, I thought I merely forgot to install VB with Excel, but that is not the case either. Does this mean anything to anybody? I am using Excel 2000 (I downloaded the calculator version "for all versions
older than Excel 2003"), and WindowsXP Home. Thanx!
Peace... Vader
Louvre attendant: Sacre bleu! ze frame on ze Mona Lisa broke and ze only one left iz too small. Andre, bring me ze scissors!
One sub to rumble them all. One sub to shake them. One sub to humble them all. And in the darkness break them.
The Overlook Theater - Not liable for injuries sustained while laughing.