The line looks OK. Is that all you have..Where is this code placed?

If this post helps click Yes
---------------
Jacob Skaria


"Risky Dave" wrote:

Hi,

Please explain what is wrong with this:

Dim sMonth as string

smonth = format(Sheets("ChartsP").Range("a1").Value, "mmm-yy")

I am getting an error message: "Wrong number of arguments or invalid
property assignment

TIA

Dave