How to quickly hide unused cells, rows and columns in Excel – Scroll area with VBA A1:E50 The Sub below is assigned with macro to button Limit Scroll to existing rows and columns for ‘Sheet1’ Watch video on YouTube Sub UnhideAndUnscrollSheet() ‘Button <<Limit Scroll to existing rows and columns for ‘Sheet1’>> Dim ws As Worksheet Dim lastRow As Long Set ws = ThisWorkbook.Sheets(“Sheet1”) ‘ Unhide all rows and columns ws.Rows.Hidden = False ws.Columns.Hidden = False ‘ Set cell B1 to bold ws.Range(“B1”).Font.Bold = True ‘ Set headers in row 3 to bold ws.Rows(3).Font.Bold = True ‘ Set all columns to font size 13 ws.Cells.Font.Size = 13 ‘ Set cell B1 to font size 16 ws.Range(“B1”).Font.Size = 16 ‘ Set all rows and columns to a reasonable height and width ws.Rows.RowHeight = 15 ‘ You can adjust this value as needed ws.Columns.ColumnWidth = 20 ‘ You can adjust this value as…

How to calculate discount, sale price and profit margin after discount? 1) Find the original price (for example 90€) 2) Get the discount percentage (for example 20%) 3) Calculate the savings: 20% of 90€ = 18€. 4) Subtract the savings from the original price to get the sale price: 90€ – 18€ = 72€. 5) Subtract Buy Price from the Sale Price and divide it by Sale Price to get the Profit margin after discount: (72€ – 50€)/72€=30,56% You’re all set! #softexperia #mindstormGR #excel_skills

Hide and Show the Excel Interface Here you can see the code to hide and show the Excel Interface. Watch the video on YouTube : https://youtu.be/DUawostxMsc #mindstormGR #vbacode #excel / www.mindstorm.gr

Calculate loan amount and monthly payment / Υπολογισμός ποσού δανείου και μηνιαίας δόσης για 5 διαφορετικά ετήσια επιτόκια YouTube Video & VBA code credit : Trifon Papadopoulos #mindstormGR / www.mindstorm.gr

How to freeze and Unfreeze given columns and rows in Excel with VBA code (in english) Video credit : Trifon Papadopoulos VBA Code #mindstormGR / www.mindstorm.gr