| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change formula dynamically
hi,
i have the following in a cell: =pivot!$D$70 so the cell is formattd as a percentage, like 3.0% i would like to know if there is a way i can change this dynamically using VBA, so it would read like *3.0% I tried sheets("sheetname").range("C1").formula = "*" & "=pivot!$D$70" but this did not work. Im not sure how to make this work. Thanks in advance, geebee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change formula dynamically
After the formula goes in:
sheets("sheetname").range("C1").NumberFormat = """*""0.0%" -- Gary''s Student - gsnu200761 "geebee" wrote: hi, i have the following in a cell: =pivot!$D$70 so the cell is formattd as a percentage, like 3.0% i would like to know if there is a way i can change this dynamically using VBA, so it would read like *3.0% I tried sheets("sheetname").range("C1").formula = "*" & "=pivot!$D$70" but this did not work. Im not sure how to make this work. Thanks in advance, geebee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I dynamically change a file link in a formula? | Excel Worksheet Functions | |||
| Dynamically Change date in Formula | Excel Worksheet Functions | |||
| How to dynamically add/change Reference? | Excel Programming | |||
| Dynamically change cell range in formula by background color? | Excel Programming | |||
| Change Axes Scale Dynamically | Charts and Charting in Excel | |||
Linear Mode
