Thread: Prompting a macro to run on change of cell content
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
  
Posts: 1
Default Prompting a macro to run on change of cell content
Try this for each of your If Then statements:

If Range("C2").Value = Range("A2").Value Then
ActiveSheet.Shapes("Image1").Select
Selection.Copy
Range("B10").Select
ActiveSheet.Paste
End If

Let me know how thet works... - Piku

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote