Thursday, December 17, 2020

remove text wrap &open calculator & unmerge cell & date in header setup

 remove text wrap 

Sub RemoveTextWrap()

Range("A1").WrapText = False

End Sub

unmerge cell

Sub UnmergeCells()

Selection.UnMerge

End Sub

open calculator

Sub OpenCalculator()

Application.ActivateMicrosoftApp Index:=0

End Sub

date in header setup

Sub DateInHeader()

With ActiveSheet.PageSetup

.LeftHeader = ""

.CenterHeader = "&D"

.RightHeader = ""

.LeftFooter = ""

.CenterFooter = ""

.RightFooter = ""

End With

End Sub


No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...