Appium Tutorial

This Appium tutorial is for learners and beginners, which provide you the conceptual knowledge about the Appium Automation testing tool. In this tutorial, we are going to discuss the following topics:- What is Appium?Different types of Apps.Advantages of...

VBA runtime error 1004

What is 1004 error?  VBA 1004 Error, also known as object-defined or application-defined, is a runtime error in VBA, usually, if the specified range does not exist in the worksheet or if the Application or the object if not appropriately defined. Error...

JavaScript Arrays

JavaScript Arrays: JavaScript Arrays are a type of variables that allows us to store the individual or the group of values under a single variable. What is an Array in JavaScript? The array is a special kind of variable that can hold the group of values at a time.We...

Javascript loops

Loops in JavaScript: Loops are used to execute a specific piece or block of code repeatedly until the given condition is satisfied. What is a Loop? Almost all loops contain a certain process and this process is defined by the users according to their requirements. For...

VBA Not Equal Operator

What is VBA Not Equal Operator? VBA Not Equal binary operator (“<>”) is a logical function that is used to check if the specified values are not equal or not. This operator compares the operand for a strict inequality, and the result type is Bool. If both the...

VBA Screen Updating

What is VBA Screen Updating property? Screen Updating is a VBA property which is used to display the output generation while running the code. If this property is enabled, we could see the output (numbers, text, alphabets, or pattern) getting generated on the...

How to convert epoch date to time?

How to convert epoch date to time? The concept of the epoch is vital for computation purposes. Epoch is nothing but the total milliseconds passed from 1st January 1970. This concept does not include leap seconds. It is necessary to use epoch dates in many programming...

Declaring a Variable in VBA

Declaring a Variable A variable is broadly described as a storage location combined with a name and representing a specific value. Declaring a variable is instructing the computer to reserve space in memory for later use. Syntax for Declaring Variable Scope...

For Next loop in VBA

For Next Loop The ”For Next” loop is used for a fixed number of times. It works by implementing the loop for the specified number of times. In this, the user specifies how many times they want the loop to run and need to define what they want the macro to do...

VBA Pivot Table

What is a Pivot Table? One of the most powerful features of Excel VBA is the Pivot Table. A pivot table is a VBA tool that is used to create summary reports from datasets irrespective of their sizes with just a click of a button. We can easily automate pivot tables...

VBA Pivot Table Grouping

VBA- Pivot Table Grouping For an instance, if in our pivot table, we have 11 different age groups from 20 to 30 –  but there might be a possibility that we had 30 different age groups say from 20 to 50 – this will effectively increase the size of the pivot...

Go-To Special function in Excel

Go-to Special The Go-To Special function in Excel allows you to select all cells that meet certain criteria quickly. This command is used to identify specific cells – the ones which are used more have been listed below – Comments – select only the cells that...

VBA Updating Pivot Table

VBA- Updating Pivot Table The pivot table is an important feature to explore, summarize, and interpret the bulk amount of data. It helps data evaluating, reviewing, as well as making useful interpretations of it. But the problem with the Pivot table is that it needs...

VBA Charts

What is a Chart? A chart is used to visually show numbers or data in a spreadsheet (or spread over multiple spreadsheets) so that the end-user can look at the chart and interpret the results or observe the trends easily. Excel gives an advantage to the user to create...

Steps to Create a Chart in VBA

Steps to Create a Chart Charts are created either by directly working with the chart variable object that defines the chart data or by ChartObject method. In order to get to the object without an existing chart, you create a ChartObject on a given Worksheet and then...

VBA Charts Basic Operations

VBA Charts- Basic Operations The Chart Object in Excel VBA represents the collection of all the charts sheet present in a workbook. A chart can be either an embedded chart or a separate chart sheet. The Chart object excludes all embedded...

VBA Regex

What is a Regex? Regex stands for Regular Expression is basically a pattern matching strings within another string. They are supported in many languages, including .net, C++, Python, etc. They are necessarily a sequence of characters that act as a search algorithm and...

VBA VBScript Regex Methods Regex

VBA VBScript Regex Methods Regex The VBA Regex supports 3 methods which are as follows: ExecuteReplaceText Execute The execute method is used to extract a match from the given based on the defined matching Regex pattern. It returns an Object which retains all the...

VBA Regex Pattern Validation

VBA Regex Pattern Validation The key purpose of using Regex in VBA was to validate the data and extract the same category of data. There are certain formats that are standard and are followed worldwide. Following those standards, we can extract and list all the values...

Flutter installation on MacOS

Flutter installation Now, we are going to see how we can install flutter in macOS. Pre-Requisites For Installing Flutter Knowledge of OOPs (object oriented programming) and familiarity with programming languages like Java,C,C++ etc. is a must before starting with...

Pin It on Pinterest