View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Change object formula without selecting first ?

Have you tried Activesheet.shapes("Pic1").formula = ""

NickHK

wrote in message
ups.com...
Hi All,

I have a procedure that remove camera objects formula,
but still select them first before remove the formula ,,, is it
possible to remove em without select ?

Here is the sample code :
Activesheet.shapes("Pic1").select
selection.formula = ""

Any help will be appreciated,,,

Tks
Halim