I have a rectangle that is x in length. And I want to draw I line at x/2 or x/3 (link the ratio to a cell). Is this possible????
Cheerio!
All help greatly appriciated
I have a rectangle that is x in length. And I want to draw I line at x/2 or x/3 (link the ratio to a cell). Is this possible????
Cheerio!
All help greatly appriciated
Last edited by mrsuperunreal; 10-16-2017 at 02:58 PM.
Try this for "Rectangle 1"
Place the denominator 2,3 or 4 etc. in "A1"
Please Login or Register to view this content.
Ohh that works very nice. I'll play around with it but it should do the job. My alternative was to setup a chart and move it to the back, but this is much more elegant. Thanks a million. Just for interest its for working with labels. And determining the space you can give to the front or the back.
May I ask one more thing, would there be a code for a button to clear the line? - I apologies this is not the exact forum but certainly follows the thread.
Thanks again!!!!
I just realized that my last request my not be so easy as each time you draw a line it gets a new name. So no problem if its not going to work using a button. Maybe just good old select and delete is what should happen. Anyway love to hear your thoughts. Thanks.
Something like this seems to work:-
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks