Footer value does not convert $[Page] to the page number (C#)

[mattymc]

In my Excel add in, When change the footer to something like this:

mySheet.PageSetup.CenterFooter = "Page &[Page] of $[Pages]";

I get exactly "Page &[Page] of $[Pages]" in the footer when I print, instead of "Page 1 of 3". If I do this in a macro it seems to convert properly.

Any Ideas?

Thanks in advance!

 

[RSXchin]

"Page " & [Page] & " of " & $[Pages]

Maybe?

 

[mattymc]

That's not it. That isn't C# syntax.

I appreciate the attempt though!

 

[RSXchin]

First of all... how are you using C#?
Secondly, why AREN'T you using VBA?

 

[Norie]

Shouldn't the $ be another &?