Problem with a macro and rectangle

1

1234

Hi, guys

I have this macro that puts an object (rectangle shape) of a size that
represents 24 inside a range of cells

The problem is that the X,Y position of the object isn´t always the
same. So, for example, if we put a rectangle with a size of 190, its
default value is 630. What I want to do is that the value 190 gets
saved when the new macro is run again and if it changes to 240, this
would be the default vakue for the next time the macro is run.

I don´t know if this is too difficult.

Thank you so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a simogram in Excel using rectangles 0
Powerpoints macro block my animation 0
Run macro from shape when runnig macro in Excel 2007 4
Macro case 2
problem with a macro autofilter to delet rows 6
rectangle 2
Macro Runtime errors 8
Macro to select all the filled cells in a worksheet? 42

Top