After the last trip to Chikmaglur, my gang had been anxiously waiting for the next trip. It sure did capture everyone’s attention and peaked their interests! With our priorities set towards work and daily hustles, we needed a break in our routine and needed to get out of the concrete jungle. So we did what…
Sub DeleteActiveWorkbook() If Application.ProtectedViewWindows.Count > 0 Then Application.ActiveProtectedViewWindow.Edit End IfDim xFullName As String xFullName = Application.ActiveWorkbook.FullName ActiveWorkbook.Saved = True Application.ActiveWorkbook.ChangeFileAccess xlReadOnly Kill xFullName Application.ActiveWorkbook.Close False End Sub
I began 2019 with a simple thought in my mind. “Change is the only constant in life. Time to shake things up in my life and bring about a change”. Boy, did I change! To travel is better than to arrive. A divine saying but I just wanted to reach a destination, experience luxurious service,…
Sub Namelist() ‘Lists the sheet names in a workbook Dim i As Integer Sheets.Add Before:=Sheets(1) For i = 2 To Worksheets.Count Sheets(1).Cells(1, 1).Value = “Worksheet names” Sheets(1).Cells(i, 1).Value = Worksheets(i).Name Next End Sub
Sub Unhide() ‘Unhides sheets in a workbook Dim x As Worksheet For Each x In Worksheets x.Visible = xlSheetVisible Next End Sub
More often than never, we wait for our next challenge in our career path. There are those who eagerly and anxiously wait for a chance to pursue what makes them move to the next step or next level. They meticulously plan their paths to glory. Then there are those who don’t plan and believe in…
LEFT is an excel formula which is used to extract the LEFT most part of the data. This formula can be used when we need specific characters from a text in a cell. Formula: =LEFT (text, [num_chars]) Below is an example: In the above example, the LEFT formula is being used to retrieve 5 LEFT most…
RIGHT is an excel formula which is used to extract the right most part of the data. This formula can be used when we need specific characters from a text in a cell. Formula: =RIGHT (text, [num_chars]) Below is an example: In the above example, the RIGHT formula is being used to retrieve 4 right most…
TRIM is an excel formula that is used to remove extra spaces before or after a text in a cell. TRIM can be used when cleaning up text that has come from other applications or environments. Formula: =TRIM(text) Below is an example: In the above example, the TRIM formula is being used to remove the spaces before…
