User Posts: Sanjida Ahmed
0
Delete Blank Columns in Excel (3 Ways)
0

This article will show you how you can delete blank columns in Excel in three effective and easy ways. Download Workbook You can download the practice ...

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

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)
0

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 (3 Ways)‌
0

We all know how to copy and paste columns and rows in Excel by dragging and dropping. But what if you have thousands of rows in your worksheet which you want ...

0
How to Transpose Columns to Rows In Excel (6 Methods)
0

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 (6 Methods)
0

Working with a big amount of data in Excel and keeping everything organized is hard. Sometimes you may want to move a particular row to another area of your ...

0
How to Add Rows in Excel with Formula (5 ways)
0

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

ExcelDemy
Logo