View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] halimnurikhwan@yahoo.com is offline
external usenet poster
 
Posts: 113
Default Change object formula without selecting first ?

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