Get cell address (range) from shape location

This one should be easy but I keep running into trouble. Can someone please give me the proper syntax for getting the range of the topleftcell of a shape?

I'm making a scheduling tool for work and I'm representing scheduled jobs on a calender by grouping a textbox (which fires a jobedit macro on click) and a rectangular frame (to enable user to drag the job to a different position in the schedule). The easy part is calling the names of all shapes on the sheet, and filtering them by type and name.

For some reason, the hard part has been getting the address of the topleftcell of each job. I've been using some messy workarounds using .left and .top but I'd love to simplify the code by using range variables instead.

Please Login or Register  to view this content.

Object variables (and a range variable is one) require Set, and you want to assign the cell, not the address property (which is a string)

Please Login or Register  to view this content.

You're welcome.