VBA Excel: Automate Headers with Date

Name: VBA Excel: Automate Headers with Date
Uploaded: Nov 15, 2022
Duration: 295 s
Description: In this video, I demonstrate how to write VBA code that will automatically generate the current date as a header on all of the sheets within an active tab. Code Below: Sub HeaderWithDate() With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&D" End With End Sub

VBA Solutions Consulting124 subscribers

223 views

Nov 15, 2022

4:55

In this video, I demonstrate how to write VBA code that will automatically generate the current date as a header on all of the sheets within an active tab. Code Below: Sub HeaderWithDate() With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&D" End With End Sub

Download

1 formats

Video Formats

360pmp45.3 MB

Download

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.