| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change object formula without selecting first ?
Hi Nick,
I've tried that but doesn't work ... ... ... ... ... ... ... thnks, halim NickHK menuliskan: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell and Object change | Excel Discussion (Misc queries) | |||
| selecting columns to change format | Excel Worksheet Functions | |||
| change size of object | Excel Programming | |||
| Selecting object | Excel Programming | |||
| Selecting cells which do not meet a formatting criteria, and assigning a Range object to these. | Excel Programming | |||
Linear Mode
