less than 1 minute read
Loop through each sheet in all open workbooks and remove the page break lines
Sub DisablePageBreaks() '// vars Dim Wb As Workbook Dim Sht As Worksheet '// optimise Application.ScreenUpdating = FALSE '// loop thruogh sheets and hide page breaks For Each Wb In Application.Workbooks For Each Sht In WB.Worksheets Sht.DisplayPageBreaks = FALSE Next Sht Next Wb Application.ScreenUpdating = TRUE End Sub
Tags: interface-formatting, practical
Categories: vba
Updated: March 19, 2017
1 minute read
Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…
less than 1 minute read
How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…
less than 1 minute read
So you have a 0% value on one of your data labels and want to hide it?
1 minute read
Download the example workbook here: calculate-time-between-dates.xlsx