Statology

Statology

Statistics Made Easy

Skip to content
Menu
  • About
  • Course
  • Basic Stats
  • Machine Learning
  • Software Tutorials
    • Excel
    • Google Sheets
    • MongoDB
    • Python
    • R
    • SAS
    • SPSS
    • Stata
    • TI-84
    • VBA
  • Tools
    • Calculators
    • Critical Value Tables
    • Glossary

Category: Uncategorized

Uncategorized

VBA: How to Use RandBetween to Generate Random Numbers

Posted on March 24, 2023 by Zach

You can use the RandBetween method in VBA to generate a random integer between two specific values. Here are two common ways to use this…

Uncategorized

How to Use COUNTA Function in VBA (With Examples)

Posted on March 24, 2023 by Zach

You can use the CountA method in VBA to count the number of non-empty cells in a specific range. Here is one common way to…

Uncategorized

How to Subtract Days from Date in VBA (With Example)

Posted on March 24, 2023 by Zach

You can use the DateAdd function in VBA with a negative number to subtract a specific number of days from a date. Here is one…

Uncategorized

How to Add Days to Date in VBA (With Examples)

Posted on March 24, 2023 by Zach

You can use the DateAdd function in VBA to add a specific number of days to a date. Here is one common way to use…

Uncategorized

How to Use Wildcards in VBA (With Examples)

Posted on March 24, 2023 by Zach

You can use the Like operator in VBA along with the following built-in wildcard characters to search for specific patterns in strings: * : Matches…

Uncategorized

How to Calculate Absolute Values in VBA (With Example)

Posted on March 23, 2023 by Zach

The absolute value of a number represents the distance between the number and zero. To calculate absolute values in VBA, you can use the Abs function.…

Uncategorized

How to Transpose a Range in VBA (With Example)

Posted on March 23, 2023 by Zach

You can use the following basic syntax to transpose a range using VBA: Sub TransposeRange() ‘specify range to transpose MyRange = Range(“A1:B5”) ‘find dimensions of…

Uncategorized

VBA: How to Convert Date to Week Number

Posted on March 23, 2023 by Zach

You can use the following basic syntax in VBA to convert a date to a week number: Sub FindWeekNumber() Dim i As Integer For i…

Uncategorized

How to Calculate Time Difference in VBA (With Examples)

Posted on March 23, 2023 by Zach

You can use the following basic syntax in VBA to calculate the difference between two times: Sub FindTimeDifference() Dim i As Integer For i =…

Uncategorized

VBA: How to Use IsNumeric to Check if Cell is a Number

Posted on March 23, 2023 by Zach

You can use the IsNumeric function in VBA to check if a given cell is a number. This function will return True if the value…

Posts navigation

Page 1 Page 2 … Page 417 Next Page

Search

ABOUT

Statology is a site that makes learning statistics easy by explaining topics in simple and straightforward ways. Learn more about us here and follow us on Twitter.

Statology Study

Statology Study is the ultimate online statistics study guide that helps you study and practice all of the core concepts taught in any elementary statistics course and makes your life so much easier as a student.

statology study

Introduction to Statistics Course

Introduction to Statistics is our premier online video course that teaches you all of the topics covered in introductory statistics. Get started with our course today.

introduction to statistics

Recent Posts

  • VBA: How to Use RandBetween to Generate Random Numbers
  • How to Use COUNTA Function in VBA (With Examples)
  • How to Subtract Days from Date in VBA (With Example)
© 2023 Statology | Privacy Policy
Wisteria Theme by WPFriendship ⋅ Powered by WordPress