User Posts: Sanjida Ahmed
0

## How to Delete Blank Columns in Excel (4 Quick Ways)

In this article, we will learn about how you can delete blank columns in Excel. Blank columns can create problems while formula calculation or exporting data. ...

0

## Excel Current Date Formula (with 11 Easy Examples)

To get the current date in Excel, you generally have to utilize the TODAY() formula. This article will show you the various ways of how to apply the TODAY() ...

0

## What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)

This article will show you the formula of multiplication in Excel for multiple cells in 3 simple ways. Download Workbook You can download the practice ...

0

## How to Copy and Paste Thousands of Rows in Excel

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...

0

## How to Transpose Columns to Rows in Excel (8 Easy Methods)

Everyone has their own point of view when visualizing and representing data. Some may feel comfortable working with data when they are in the horizontal ...

0

## How to Move a Row in Excel (8 Quick Tricks)

In truth, working with large sets of data in Excel and keeping everything organized is hard. Sometimes you may want to move a particular row to another area of ...

0

## How to Add Rows with Formula in Excel (5 Easy Methods)

While working with a large dataset in Excel, you want to know the total value of a particular row or multiple rows. In Excel, you can do that in many ways. ...

Browsing All Comments By: Sanjida Ahmed
1. 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.

2. 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.

3. 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?

4. Hello Maurice,
Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS