=Right Function

[Sanj]

Hi All

Can any one tell me what this means:

= Right((Cells(2, 2)), 4)

In a cell where the contents are a date lets say
11/06/2004, I'd like to get the year from the date.

Can you help?

 

[Don Guillett]

What you have is vba
range("a1")= Right((Cells(2, 2)), 4)
to use a formula, just use
=year(b2)
and format as text or number without the comma

 

[Frank Kabel]

Hi
this gets the 4 rightmost characters of cell B2. But this
won't give you the expected result in B2 contains a date
(as Excel stores dates internally as numbers). To get the
year in VBA try:
msgbox Year(activesheet.cells(2,2).value)

 

[Guest]

that work brilliantly, now I need to add that year
automatically to a graph title

can you help?

 

[Frank Kabel]

Hi
try the following
- select your graph
- select the title textbox
- hit F2
- enter the equation sign '='
- now select with yoour mouse the source cell and hit ENTER