i want copy new picture in cell using macros before copying new picture how can checked particular cell having picture or not, matching shape.topleftcell current cell not working me, appreciated!
' not working every picture sub deletecell(curcell) 'curcell=activewindow.activecell dim sh shapes each sh in activesheet.shapes if sh.topleftcell.address = curcell.cells.address sh.delete end if next end sub thanks
- change
sub deletecell(curcell)sub deletecell(curcell range) - change
dim sh shapesdim sh shape - change
curcell.cells.addresscurcell.address
so code looks this
sub deletecell(curcell range) 'curcell=activewindow.activecell dim sh shape each sh in activesheet.shapes if sh.topleftcell.address = curcell.address sh.delete next end sub
Comments
Post a Comment