User Posts: Musiha
You may need to use the same values in some cells. In that case, you don’t need to insert the same cell value repeatedly, simply you can merge and center those ...
Sometimes you may need to use an implicit intersection operator in Excel. In this article, I will show you how, and where to use an implicit intersection (@) ...
Sometimes you may need to use some combination of functions in Excel for searching a particular text or returning the answer as text. So, if you are looking ...
Sometimes for data visualization, you may need to create a floating bar chart in Excel. So, if you are looking for how to make this chart in Excel, then you ...
A date picker is one kind of dynamic calendar that allows the user to select a particular date. So, if you are looking for how to create a date picker with the ...
To increase the visuality of a data range, you may need to shade the area between two lines of an Excel chart. So, if you are looking for how to shade the area ...
Sometimes you may need to draw a shape or an object in Excel. So, if you are looking for drawing objects using VBA code in Excel, then you have come to the ...
Sometimes you may need to calculate volatility using the Black-Scholes formula in Excel. So, if you are looking for how to calculate volatility for the ...
When you have a dataset that contains numbers with more than 4 digits, then you may need to scale them for lowering those digits. So, if you are looking for ...
Sometimes for business or institute purposes, you may need to create a project pipeline in Excel to track all your projects easily. So, if you are looking for ...
An intercept of two trend lines represents the solution for these equations and you may need to find that point using Excel. So, if you are looking for how to ...
Sometimes you may need to join tables in Excel for passing information. So, if you are looking for how to join tables in Excel then you have come to the right ...
Sometimes for data visualization, you may need to make a chart. Furthermore, a chart slider is a more interesting and useful thing for data visualization. You ...
Skewness is a basic statistical concept. Sometimes, you may need to calculate the skewness in Excel. So, if you are looking for how to calculate the skewness ...
If you are heading to a new business, then you should know the calculation of the multi-product break-even analysis. So, if you are looking for how to do ...
- 1
- 2
- 3
- …
- 7
- Next Page »
Hello MP ROY,
Thank you for your comment. I have tried these codes and they are working perfectly, except the code in Example3. For that particular code, you can use a new workbook. While I was using a new workbook the code has been perfectly worked there. But you have to be careful about the name of worksheet. You have to use exact worksheet number and name in the code.
Regards,
Musiha
Team ExcelDemy
Hello, J KUMAR.
Thank you for your comment. I have tried the code too and the code is absolutely right and perfectly working. But you are facing problem because most probably your device is running out of virtual memory. So, when you are trying this code in Excel, at that time you should close all other applications. Also, you should use an individual module for this code.
Hello, CHRIS.
Thank you for your comment. Actually, with the help of method 4, you are converting numbers into text. But when you re-entered any new value then the cell will hold that value excluding the apostrophe. Basically, the past value along with the apostrophe completely had gone away. So, if you want to keep the apostrophe then you should select that cell (containing new value) and run the Macros again. Then, you will see the apostrophe again with the new value.