SaravananJayaraman

 Welcome to the blog.  Here we will learn and Hide and Unhide the Sheets using VBA Code in a very easy way. In this blog we will learn how to hide and unhide multiple sheets at one go using the VBA Code. We will be using the excel file used in last blog where we created multiple TABs. We will try to  learn to hide these sheets and unhide these sheets. The Code will look Like this You can copy the code from below and use it in your excel. Below code is to Hide the sheets ----------------- Sub Hide_Sheets() Tot_Sheet = ActiveWorkbook.Sheets.Count     For i = 2 To Tot_Sheet         Sheets(i).Visible = xlSheetHidden     Next i End Sub ---------- Below code is to UnHide the sheets --------- Sub Unhide_Sheets()     For Each Worksheet In ActiveWorkbook.Worksheets         Worksheet.Visible = xlSheetVisible     Next Worksheet End Sub --------- Now let us learn how to write the code with explanation Not...

Welcome to the blog. Without wasting anytime we will get straight to the point. Here we will learn and create Macros in a very easy way. In this blog we will col our tabs with different colours for each tab. Here  is the Data which we will be using to colour the Tabs. In this sample data, there are 10 Cities and Sheets with these city names. You are tasked to colour these 10 Tabs with colour. Each tab colour should be different from each other.  Now let  us write code which will colour tabs.  The Code will look Like this You can copy the code from below and use it in your excel ----------------- Sub Change_Tab_Colour()          ActiveWorkbook.Sheets("Bengaluru").Tab.Color = RGB(255, 0, 0)     ActiveWorkbook.Sheets("Chennai").Tab.Color = RGB(0, 255, 0)     ActiveWorkbook.Sheets("Hydrabad").Tab.Color = RGB(0, 0, 255)     ActiveWorkbook.Sheets("Trivindram").Tab.Color = RGB(0, 0, 0)     ActiveWorkbook.Sheet...

Welcome to the blog. Without wasting anytime we will get staraight to the point. Here we will learn and create Macros in a very easy way. In this blog we will create multiple tabs based on the Locations. Here  is the Data which we will be using to create Tabs. In this sample data, there are 10 Cities and you are tasked to create 10 Tabs with the city names. Manually it can be done. Create 10 Tabs and rename each one. Just imagine if you have 200 cities. It would be very time consuming and tiring job. Now let is create a code which will create 10 tabs and rename it with the cities. The Code will look Like this You can copy the code from below and use it in your excel ------------------------- Sub Citi_Name()          Range("A1").Select     Selection.End(xlDown).Select     TotCity = ActiveCell.Row - 1               For i = 1 To TotCity                  Tot...

Hello and welcome to PawCast the  Podcast covering aspects of dog and everything associated with dogs. I am Saravanan Jayaraman your host for the show. I love to spread the little knowledge which I have. I will try to do the same here. This is episode 1.  In this introductory podcast I will talk about the overview. The concept of having the dog for safety is slowly changing now it is it's not just a pet, but a friend, a child, an emotion a pride, companion to the mind and soul.  The pandemic has changed many perspectives. The pandemic especially in Lockdown people started feeling lonely. Though the pandemic brought in lot of hardships,  it also brought in many good things.  People started to start new hobbies like gardening. Many wanted to bring in new family member -  the dog.  Dog in many houses become integral part of their life,  but there is a flip side to it. Many abandoned the dogs as they were not able to maintain its expenses. Dog owner...