Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Reba Wright   on Sep 08 In MS Office Category.

  
Question Answered By: Rochelle Elliott   on Sep 08

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.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 


Tagged: