Thread: is there a property instead of ScaleWidth method
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder Rob van Gelder is offline
external usenet poster
  
Posts: 37
Default is there a property instead of ScaleWidth method
Are you after the Width property?


On 14-Dec-2009 03:58, EXCEL　NEWS wrote:
hi,
when i use ScaleWidth method like these

ActiveSheet.Shapes("Object 8").Select
Selection.ShapeRange.ScaleWidth 0.48, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.48, msoFalse, msoScaleFromTopLeft

i can make the shape smaller,

but how i can get the scale which has been "ScaleWidth"ed ,

is there a property instead of method

thanks
Reply With QuoteReply With Quote