Home: Welcome

Welcome to the KalpTalk

Blog

Kalpesh Agrawal

Nov 19, 2020

VBA Change the color of the Sheet Tab

This topic is not important in general, but if you want to distinguish all the sheet tab from each other, then you can change the tab...

Kalpesh Agrawal

Nov 18, 2020

VBA Copy, Move, Hide, and Unhide Sheet

Copy and Move the sheet Let’s learn how to copy and move the sheets. Hide and Unhide Sheets If your Excel sheet contains some...

VBA Add sheet, rename the sheet, and add a sheet with the name

Kalpesh Agrawal

Nov 17, 2020

VBA Add sheet, rename the sheet, and add a sheet with the name

You can add the sheet, change the name of the sheet and add the sheet with the name in the Excel workbook using the VBA code given below....

VBA Sheet Referencing & Getting Sheet Name

Kalpesh Agrawal

Nov 16, 2020

VBA Sheet Referencing & Getting Sheet Name

Sheet Referencing Follow the code, you will learn how to reference the sheet. Getting sheet name In Excel, when you are working on...

Kalpesh Agrawal

Nov 15, 2020

Select and Activate the cell

In Excel, if you want to select a single cell then just click on that cell, and if you want to select multiple cells then press SHIFT and...

VBA Hide and Unhide the Columns and Rows

Kalpesh Agrawal

Nov 14, 2020

VBA Hide and Unhide the Columns and Rows

If you want to prevent confidential data inserted into your Excel sheet, you can hide the rows and columns. I have been inserted some...

Kalpesh Agrawal

Nov 13, 2020

VBA Column Width & Row Height

Sometimes if the text size is more than the column width, then you can directly set it up by double click on a particular column, the...

Kalpesh Agrawal

Nov 12, 2020

VBA Clear and Delete Cells

Clear Cells If you have been doing many tasks with the fonts like, bold the font, Underline the font, Change the background color of...

Kalpesh Agrawal

Nov 11, 2020

VBA Insert the Rows and Columns

Let’s insert the rows and columns in an Excel sheet using VBA code. When inserting data in Excel, if you came to know that you have not...

Kalpesh Agrawal

Nov 10, 2020

VBA Merge- Unmerge Cells

In excel you can merge-unmerge the cells to show the data more precisely. If you want to give some title to the table, and graph in the...

Kalpesh Agrawal

Nov 9, 2020

VBA Text Orientation

If you want to tilt the text from some angle, you have to use the orientation part. Related: VBA Copy-Paste and Wrap text Related: How to...

Kalpesh Agrawal

Nov 8, 2020

VBA Paste Special

We learned to Paste the data simply in the previous topic…Now let’s learn to Paste special. In Excel, Paste special is a very important...

Kalpesh Agrawal

Nov 7, 2020

VBA Background Color

In Excel, you can change the background color of the cell by clicking just one button but in VBA you have to write the code given below...

Kalpesh Agrawal

Nov 6, 2020

VBA Font Alignment

Font Alignment is a useful feature in Excel, and you can use it by VBA coding also, By aligning text in Excel, you can show it...

Kalpesh Agrawal

Nov 5, 2020

VBA With Block

Do you know the usage of With Block function in VBA? Let's learn the usage of VBA With block. Related: VBA Font Related: Excel VBA common...

5 6

8 9

About

Hi, This is Kalpesh Agrawal.

I have cleared 6 Actuarial Exams, including CM1(CT1+CT5), CB2(CT7), CS1(CT3), CS2(CT4+CT6), and CM2 (CT8) all in the first attempt.

Six Sigma Green & Black Belt
Microsoft SQL Server Specialist
Microsoft Excel-2013
Tableau Desktop Specialist

I have work experience as a Data Analyst in an IT company and worked with International Clients. Currently, I am working as an Actuarial Analyst at IIB.

Connect with me on LinkedIn: Kalpesh Agrawal

About Me