View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
boe boe is offline
external usenet poster
 
Posts: 1
Default Macro to remove pictures from cut and paste

Thank you so much - this worked like a charm!

"keepITcool" wrote in message
...



"boe" wrote:

Sub ButtonRemove()
Dim myshape As Shape
For Each myshape In ActiveSheet.Shapes


if myshape.topleftcell.column<1 then

myshape.Delete


endif

Next myshape
End Sub



2 lines added :)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool