Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy past function on cell containing selective formula
Hi,
I am extensive user of Hyperion Smart view. Usuualy I sent out report after converting them into value as most of the recipeint do not have access to Hyperion server. This make reports un-editable as all formula e.g. sum, average etc are also convereted to values. Any idea as to how to write a code which converts only cells with HSGETformula to value and leave others alone? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy past function on cell containing selective formula
Long shot
For Each cell In Selection If cell.Value Like "*HSGET*" Then cell.value = cell.Value End I Next cell -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Abid" wrote in message ... Hi, I am extensive user of Hyperion Smart view. Usuualy I sent out report after converting them into value as most of the recipeint do not have access to Hyperion server. This make reports un-editable as all formula e.g. sum, average etc are also convereted to values. Any idea as to how to write a code which converts only cells with HSGETformula to value and leave others alone? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy past function on cell containing selective formula
Abid,
Dim myC As Range For Each myC In Cells.SpecialCells(xlCellTypeFormulas) If Left(myC.Formula, 6) = "=HSGET" Then myC.Value = myC.Value Next myC HTH, Bernie MS Excel MVP "Abid" wrote in message ... Hi, I am extensive user of Hyperion Smart view. Usuualy I sent out report after converting them into value as most of the recipeint do not have access to Hyperion server. This make reports un-editable as all formula e.g. sum, average etc are also convereted to values. Any idea as to how to write a code which converts only cells with HSGETformula to value and leave others alone? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function based on blank cell and date past due | Excel Worksheet Functions | |||
selective copy data from table | Excel Programming | |||
Run a macro to copy selective items | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
copy / paste selective rows | Excel Discussion (Misc queries) |