VBA Text Format

[SammiBoi]

Hi,

I am trying to make a vba macro to save my workbook name with a variant of the spreadsheet month. (a 2 digit month... ie: March is 03)

I wanted to use the following command but VBA doesn't seem to recognize it.
TEXT(Month(Range("B3"), "00")

Is there any work around?

Thanks
Sam

 

[Blade Hunter]

format(Range("B3").Value,"MM")