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

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
>
>