Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to macro
Hallo all
Is there a way content from cell (for example content of A1, A2, A3 and A4) put in macro : Sub MakroN1() ActiveSheet.Shapes.AddShape(msoShapeRectangle, A1, A2, A3, A4). _ Select End Sub In short, as you can see, intent is that cell contents through macro command draw a square. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to macro
With no checking to make sure the values make sense:
Sub MakroN1() with activesheet .Shapes.AddShape(msoShapeRectangle, _ .range("A1").value, _ .range("A2").value, _ .range("A3").value, _ .range("A4").value).Select end with End Sub On 07/27/2010 03:27, eLaCiD wrote: Hallo all Is there a way content from cell (for example content of A1, A2, A3 and A4) put in macro : Sub MakroN1() ActiveSheet.Shapes.AddShape(msoShapeRectangle, A1, A2, A3, A4). _ Select End Sub In short, as you can see, intent is that cell contents through macro command draw a square. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
If cell is empty then run macro otherwise skip this macro | Excel Programming | |||
macro to run a separate macro dependent on value in cell | Excel Programming | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |