Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
May 27, 2018
Solved

print in the middle section of header month, year of a cell

I have A1 with date 5/25/2018 >> upper(text(A1,"mmm")) &", " & text(A1,"yyyy")  would give MAY, 2018 - how do I put this in the middle section of the HEADER for printing purposes? or add this to...
excel
  • Man Fai Chan's avatar
    Man Fai Chan
    May 28, 2018

    Can you change the sheet name to "May, 2018" and then insert sheet name in the header? The procedure may take time but it is is a way without using vba,.

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
May 28, 2018

Mr Pieterse

Thank you for your reply.

if it is, kindly help with the VBA code..

many many thanks

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
May 28, 2018

Mr Pieterse

I think Mr Chan have the right idea.

Still, many thanks for your time..

Resources