On my sheet, I have a cell with today's date "=TODAY()" ... I have another cell with a picture of the live date (as a date reference) from last time.
Whenever I run the Macro, I want it to delete the old date pic (named "Picture 20"), copy the "live date", and paste it as a new pic where the old pic was.... And name the new pic "Picture 20" same as the old pic so it'll delete it again next time I run the macro.
I can "record" a new Macro and get the basics (I'll post below), but the problem is that I need it to name the new pasted pic the same name as the deleted pic was originally - so it'll be able to delete the pic next time I run the Macro.
Can I force it to give the newly pasted pic a specific name?
Thanks
Here is what I have...
Whenever I run the Macro, I want it to delete the old date pic (named "Picture 20"), copy the "live date", and paste it as a new pic where the old pic was.... And name the new pic "Picture 20" same as the old pic so it'll delete it again next time I run the macro.
I can "record" a new Macro and get the basics (I'll post below), but the problem is that I need it to name the new pasted pic the same name as the deleted pic was originally - so it'll be able to delete the pic next time I run the Macro.
Can I force it to give the newly pasted pic a specific name?
Thanks
Here is what I have...
Code:
Sub Date_Move_As_Pic()
'
' Date_Move_As_Pic Macro
'
'
ActiveSheet.Shapes.Range(Array("Picture 20")).Select
Selection.Delete
Range("AD17:AG18").Select
Selection.Copy
Range("K17:N17").Select
ActiveSheet.Pictures.Paste.Select
Application.CutCopyMode = False
Range("L21").Select
End Sub