Hans-Olav Posted September 14, 2020 Share Posted September 14, 2020 Hi I have a file with lots of apartments organized as symbols I have a made a worksheet listing all symbols starting with "apartment-nr" and in the next column i count them. Inside each symbol there are several spaces. Is it possible to find the total area of spaces inside each symbol? Total Net area Quote Link to comment
Pat Stanford Posted September 15, 2020 Share Posted September 15, 2020 I don't think there is any way to do this using the basic worksheet functions. It should be relatively simple to create a Worksheet Script that would take a handle to a symbol and return the area of all spaces within that symbol. Are you willing to learn something about worksheet scripts to make this happen? 3 Quote Link to comment
Hans-Olav Posted September 15, 2020 Author Share Posted September 15, 2020 If you @Pat Stanford are willing to teach me? 2 Quote Link to comment
Pat Stanford Posted September 15, 2020 Share Posted September 15, 2020 I am willing to teach. Let me look at this tonight and see what I can come up with. 2 Quote Link to comment
Pat Stanford Posted September 16, 2020 Share Posted September 16, 2020 Take a look at this thread on worksheet scripts. It either solves or comes close to solving the problem. As long as you can get through all of my blathering. ;-) Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.