Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a shape (block arrow) that I need to flip using VBA.
I recorded the action using macro recorder and got: Sheet1.Shapes("AutoShape 17").Select Selection.ShapeRange.Flip msoFlipVertical When I run these two lines in a sub all by themselves, it works and the arrow flips. When I use the same two lines embedded in code, I get: "does not support this property or method" error 438 If OldArrowDir < ArrowDir Then Sheet1.Shapes("AutoShape 17").Select Selection.ShapeRange.Flip msoFlipVertical Sheet1.Range("C7").Value = ArrowDir End If running in debug, it does hit each line, and it is crashing on the line: Selection.ShapeRange.Flip msoFlipVertical any ideas? much thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Recorded replacement doesn't work | Excel Discussion (Misc queries) | |||
Recorded macro | Excel Discussion (Misc queries) | |||
I recorded a macro "PrintSetUp" in excel but does not work | Excel Worksheet Functions | |||
How does Set AutoShape Default work? | Excel Discussion (Misc queries) |