Sanjida Ahmed, who graduated from Daffodil International University with a degree in Software Engineering, has worked with SOFTEKO since 2021. She has written over 100 articles on Excel & VBA and, since 2022, has worked as the Project Manager of the Excel Extension Development Project in the Software Development Department. Since starting this software development, she has established an outstanding workflow encompassing a full SDLC. She always tries to create a bridge between her skills and interests in Artificial Intelligence.
To calculate Principal based on a loan, we need to execute Excel’s PPMT function, and to calculate Interest according to a loan amount, we need to apply ...
The Moving Average is also known as the Rolling Average or Running Average in Excel. In this article, we will show you how to calculate the moving average for ...
Sometimes we need to modify rows when working on a large dataset in Excel for better readability. Implementing VBA is the most effective, quickest and safest ...
Sometimes we need to hide some specific rows when using our large dataset in Excel for better readability. Implementing VBA macro is the most effective, ...
In Excel, to merge multiple cells or ranges and make it as one singular cell, Range.Merge method is used. In this article, we will show you how to merge ...
Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If you know ...
Sometimes we need to modify our large dataset in Excel by inserting rows according to specific requirements. Implementing VBA macro is the most effective, ...
Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to sort the ...
To sort in Excel with VBA, you need to apply the Range.Sort method. In this article, we will show you how to sort the column in Excel with the Range.Sort ...
Finding outliers and removing them is a very common task to analyze data in statistics, data mining, machine learning etc. There are so many ways that you can ...
Excel sheets with massive datasets are hard to deal with. But if you can filter the dataset according to your specific need, then the task becomes quite easier ...
VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function in VBA is ...
The Format function in Excel is a built-in function categorized as a String/ Text function. It is also used as a VBA function in Excel. In this article, we ...
Conditional statements are used to perform a set of actions depending on the specified condition in programming languages. In this article, we will show you ...
Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to refresh the ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Glad that we could help you. Don’t hesitate to ask if you have any more Excel related problems. Here, our experts will be happy to assist you.
Hi Jesse,
Thanks for your comment. Have you checked the method no. 2 (VBA Macro to Export Excel Contents with Specified Range to a Pipe Delimited Text File) of this article? I think that solves your problem.
Hi James, In some cases, Excel’s IsNumeric property doesn’t always produce the correct result in VBA. Could you please try If Cells(i, 1) = 103 Then instead of If IsNumeric(Cells(i, 1)) = 103 Then in your code?
Hello Maurice,
Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.