Hi Jim,
you have to use the Val function as it returns the numbers contained
in a string as a numeric value of appropriate type.
For example:
Tier1 = Val(Range("$H$743"))
or that way I prefer this method:
Tier1 = Val(Cells(743, 8).Value (the 8 represents the H as the 8th
letter in alphab
Hi Guys,
I have got a problem with a macro that put few lines from a sheet to a
chart.
First I have tried to use autofilter to arrange the necessary data
together and created the chart on that area. Unfortunately this idea
was good enough because when I released the autofilter out the whole
char
hrt name
> if chrtName = "Chart1" then
> chrt.delete
> end if
> Next
>
> --- to set other properties
> With ActiveSheet.ChartObjects("ChartName")
> .Width = 100
> .Height = 100
>
Hi Folks,
I'm working on a macro that generates a chart on the basis of just
refreshed table. But as the table refreshes each time I need to delete
the already existing chart (that is the only one chart on that sheet).
Could anyone help me please how can I get the properties/name of that
existing
