Here is the code that is giving me an endless "run" for my money, so
to speak:
Sub getJellyBean()
'
' This subroutine will select the graphic, inserted into a
' cell on the worksheet called "Quad Chart1", and paste it
' into a cell on the first worksheet called "Dashboard"
' See code below:
Sheets("Dashboard").Select 'These three lines will delete
Activesheet.Shapes.SelectAll 'the existing cell contents
Selection.Delete 'of the Dashboard worksheet.
Sheets("Quad Chart1").Select 'Copy the inserted image(a gif
Range("C2:C2").CopyPicture 'file ) into the clipboard.
Sheets("Dashboard").Select 'Now, paste that sucker onto
Range("C3").PasteSpecial 'into the associated cell on
' the Dashboard.
'That is it to my subroutine
End Sub
Please tear it apart. I'm so rusty as a programmer that I do not have
any ego to bruise. I really appreciate ANY help. I'm ready to learn
from those who know so much more than I.
Any help will be greatly appreciated.