User Posts: Sanjida Ahmed
0
How to Calculate Intraclass Correlation Coefficient in Excel
0

This article will show you how to calculate Intraclass Correlation Coefficient (ICC) in Excel. Download Workbook You can download the free practice ...

0
How to Open Word Document and Save As PDF or Docx with VBA Excel
0

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. This article will show you how to open a word document, ...

0
Macro to Convert Excel to Pipe Delimited Text File (3 Methods)
0

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. This article will show you how to convert contents from ...

0
VBA Code to Convert Text File to Excel (7 Methods)
0

Sometimes we have loads of data stored in text files. If we can transfer the contents from those text files to Excel workbook in an organized and meaningful ...

0
VBA Code for Subtotal in Excel (3 Ways)
0

In generic terms, subtotal refers to the total of one set of a larger group of sets. Excel is widely used to store crucial numeric information of students or ...

0
VBA to Split String into Multiple Columns in Excel (2 Ways)
0

Sometimes we have to deal with pretty long strings in our Excel dataset and that is not quite convenient to work with always. Implementing VBA macro is the ...

0
VBA to Hide Rows Based on Cell Value in Excel (14 Examples)
0

Sometimes we need to hide some specific rows based on various values from different cells in our large dataset in Excel for better readability. Implementing ...

0
VBA to Hide Rows Based on Criteria in Excel (15 Useful Examples)
0

Sometimes we need to hide some specific rows based on various criteria from our large dataset in Excel for better readability. Implementing VBA macro is the ...

0
VBA to Generate Multiple Lines in Email Body in Excel (2 Methods)
0

This article will show you 2 different methods on how to generate an email body with multiple lines with the VBA macro in Excel. Download Workbook You ...

0
Random Number Generator with Data Analysis Tool and Functions in Excel
0

Generating random numbers manually is a very time-consuming thing. With the help of Excel’s tools and functions, you can produce numbers in a very short time. ...

0
How to Calculate Forecast Accuracy Percentage in Excel (4 Easy Methods)
0

Calculating the Forecast Accuracy Percentage is a very familiar task to do not only for the people who work with statistics and data analysis but also for the ...

0
VBA IF Statement with Multiple Conditions in Excel (8 Methods)
0

When you want to extract results from so much data based on a certain condition, then Excel’s IF statement is a very efficient way to get that. Implementing ...

0
VBA to Add Hyperlink to Cell Value in Excel (4 Criteria)
0

Hyperlinks are a very efficient way to go from one location to another with just a single click. Implementing VBA is the most effective, quickest and safest ...

0
Difference Between Sort and Filter in Excel
0

This article will describe in detail about Sort and Filter tool of Excel. The introduction, methods, examples, uses, and advantages to sort and filter data in ...

0
Print Multiple Excel Sheets to Single PDF File with VBA (6 Criteria)
0

When we have so many worksheets in our Excel workbook, sometimes it is convenient to print all those sheets in a single PDF file for better readability. ...

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

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

ExcelDemy
Logo