Latest Posts From Adnan Masruf
,In this article, we will discuss VBA codes with Select Case and related Operator(s). The Select Case statement is one of the control structures available in ...
Adnan Masruf
Method 1 - VBA Code to Check If String Contains Any Letter Every character has a unique ASCII code and the computer recognizes them with that code. The upper ...
In this article, we will discuss Excel VBA variable types. Variables are a fundamental concept of any programming language. Different types of data are stored ...
In this article, we will discuss VBA codes to unwrap text. We often use the Wrap Text command to fit text inside a cell. In order to unwrap the text, we will ...
In this article, we will discuss VBA codes to call Private Sub from another module. A Private Sub is a subroutine that can be accessible from the module where ...
In Excel, if we need to add a new row after the last row in a large dataset, it can become tedious and time-consuming to go to the last row. Although we can ...
How to Launch the VBA Macro Editor in Excel Go to Developer Tab >> Visual Basic. The Visual Basic window is displayed. Select Insert ...
In this article, we will learn how to use Excel VBA to copy without a clipboard. Often, users need to copy data from one sheet to another or from one workbook ...
Here's an overview that shows code that uses DoEvents and Wait properties. What Are VBA DoEvents and Application.Wait Properties? When a VBA macro ...
Launching the VBA Macro Editor in Excel Before running any VBA code, you’ll need to access the VBA Macro Editor. Follow these steps: Enable the Developer ...
Method 1 - Finding Multiple Values from User Input The following code will prompt users to insert a value that they want to find and highlight all the ...
The Worksheet.Visible Property in Excel VBA The Worksheet.Visible property hides multiple sheets in an Excel file. The Visible property can have one of the ...
The Runtime Error 13 Type Mismatch in VBA is one of the most common types of errors while using VBA and occurs if the data type that is given does not match ...
Dataset Overview In this tutorial, we’ll explore how to use the SUMIFS function to exclude specific values based on criteria. Let’s consider a dataset ...
In this article, we will talk about the usage of Excel VBA Offset Within Loop. It is a very effective function in its own right. However, when combined with ...
- 1
- 2
- 3
- …
- 7
- Next Page »
See Our Reviews at
Dear Nirmal,
Could you please provide me with your Excel file that you have mentioned or some screen shots from your dataset? That would help me to understand your dataset and answer your query accordingly.
Thanks for your query.
Regards,
Adnan
Team ExcelDemy
Dear Raman,
1. First, make sure you are using MS Office 365 as they are only available in that version.
2. Secondly, make sure you are logged into your MS Excel account.
3. Thirdly, make sure to have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
If these do not work then,
-Go to File > Options > Trust Center > Trust center Settings > External Content > Security settings for “Linked data types” > Activate “Enable all Linked Data Types”
or
– Go to Options>Customize Ribbon> All Commands
– Then, choose the Datatype Command
-Add the command to a “New Group”
-Finally, restart your Excel Application.
*Also, make sure to keep your internet connection ON; as this data type is linked datatype.
*You should also see if this datatype is available in your geopolitical locaton.
Dear K,
Thanks for your query. If we add replies to the comments (Like the first picture), we can find the replies by simply looking at the initials without changing the macros (Like the second picture)