I am forced by office policy to draw floor plans in Excel rather than any of the nice drafting programs out there.
I know.
Anyway, I am wondering whether anyone has come up with a set of tips, tricks, procedures, icons, macros, etc., to facilitate this very sort of task.
By the way, beyond recording keystrokes I haven't written any macros since Lotus 123, therefore not savvy in this area.
Thank you.
I've done this and it's a pain. First I select the sheet and set row height to 9 and column to 1 to make a nice graph paper. Select a scale (1 cell = 6 inches) Adjust as necessary. Then I create furniture using Excel's drawing tools and mass produce them using copy paste. These pieces of furniture can be rotated, dragged and dropped. Also you can group shapes to make more complex shapes or link text boxes with shapes or keep certain pieces together and then move them as a group. I hope that helps. Good luck.
Last edited by ChemistB; 07-02-2010 at 11:20 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks