About PNRao

Hi, I’m PNRao—an Excel & VBA developer with 20 years in data mining, automation, and project management. Day-to-day I turn raw data into clear insight, replace repetitive work with one-click workflows, and guide teams with smarter project management. On Analysistabs.com I share battle-tested tips on Excel, VBA, SQL, Automation, Project Management, and Data Analysis—plus a growing library of free and premium Project Management Templates. My goal is to help you work faster, build sharper tools, and level up your career. Let's master data and manage projects effectively, together.

Copy Files from One Location to Another folder or directory in Excel VBA
Gallery
Copy Files from One Location to Another folder or directory in Excel VBA

Excel VBA

Copy Files from One Location to Another folder or directory in Excel VBA

PNRao2023-02-16T13:10:17+05:30

Examples to Copy Files from One Location to Another folder or directory in Excel VBA - if File does not exists in the source or already in the destination.

Copy Files from One Location to Another folder or directory in Excel VBAPNRao2023-02-16T13:10:17+05:30

VBA Code Excel Macro Examples Useful 100+ How Tos for Basic and Advanced Users

PNRao2023-03-06T14:57:05+05:30

100+ USEFUL VBA CODES & MACROS

The Most Useful VBA Codes & Macros! Do Almost Everything! We have explained verity of examples to cover most frequently used codes.

START LEARNING …

VBA Code Excel Macro Examples Useful 100+ How Tos for Basic and Advanced UsersPNRao2023-03-06T14:57:05+05:30

TIME Function in Excel
Gallery
TIME Function in Excel

Excel Formulas

TIME Function in Excel

PNRao2022-06-17T03:55:13+05:30

What is the use of TIME function? Returns the number [...]

TIME Function in ExcelPNRao2022-06-17T03:55:13+05:30

DATE Function in Excel
Gallery
DATE Function in Excel

Excel Formulas

DATE Function in Excel

PNRao2022-06-17T03:55:06+05:30

DATE Function in Excel - formula returns the number that represents the particular date. Learn Formulas, Excel and VBA with examples in our free tutorials.

DATE Function in ExcelPNRao2022-06-17T03:55:06+05:30

SUBSTITUTE Function in Excel
Gallery
SUBSTITUTE Function in Excel

Excel Formulas

SUBSTITUTE Function in Excel

PNRao2022-06-17T03:54:53+05:30

SUBSTITUTE Function in Excel - formula replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.

SUBSTITUTE Function in ExcelPNRao2022-06-17T03:54:53+05:30

Check if file Exists in Location using Excel VBA
Gallery
Check if file Exists in Location using Excel VBA

Excel VBA

Check if file Exists in Location using Excel VBA

PNRao2022-06-17T03:53:15+05:30

Example code to Check if file Exists in Location using Excel VBA. We can use FileSystemObject and FileExists, Dir functions.

Check if file Exists in Location using Excel VBAPNRao2022-06-17T03:53:15+05:30

OFFSET Function in Excel – Formula Explained with Examples
Gallery
OFFSET Function in Excel – Formula Explained with Examples

Excel Formulas

OFFSET Function in Excel – Formula Explained with Examples

PNRao2022-06-17T03:54:52+05:30

OFFSET Function in Excel - formula returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range

OFFSET Function in Excel – Formula Explained with ExamplesPNRao2022-06-17T03:54:52+05:30

Excel VBA Macros for Beginners – 15 Examples File download
Gallery
Excel VBA Macros for Beginners – 15 Examples File download

Excel VBA

Excel VBA Macros for Beginners – 15 Examples File download

PNRao2023-03-06T14:53:39+05:30

learn-vba-by-examples

Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see how to access the different Excel Object using VBA.

Excel VBA Macros for Beginners – 15 Examples File downloadPNRao2023-03-06T14:53:39+05:30

COLUMN Function in Excel
Gallery
COLUMN Function in Excel

Excel Formulas

COLUMN Function in Excel

PNRao2022-06-17T03:54:52+05:30

COLUMN Function in Excel - formula returns the column number of the given reference. Learn Formulas, Excel and VBA with examples in our free tutorials.

COLUMN Function in ExcelPNRao2022-06-17T03:54:52+05:30

ROW Function in Excel
Gallery
ROW Function in Excel

Excel Formulas

ROW Function in Excel

PNRao2022-06-17T03:54:52+05:30

ROW Function in Excel - fromula returns the row number of the given reference. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

ROW Function in ExcelPNRao2022-06-17T03:54:52+05:30

Hyperlinks in Excel VBA – Explained with Examples!

PNRao2013-04-17T00:00:00+05:30

Hyperlinks in Excel VBA - Examples to add, create and remove hyperlinks, opening files using hyperlinks and sending emails using hyperlinks in Excel VBA.

Hyperlinks in Excel VBA – Explained with Examples!PNRao2013-04-17T00:00:00+05:30

Excel VBA to Interact with Other Applications

PNRao2013-04-15T00:00:00+05:30

Another powerful feature of Excel VBA is to interact with Other Applications - Examples to deal with MS Word, PowerPoint, Access, Internet Explorer,etc.

Excel VBA to Interact with Other ApplicationsPNRao2013-04-15T00:00:00+05:30

Previous 353637 Next

PNRao

About PNRao

100+ USEFUL VBA CODES & MACROS

The Most Useful VBA Codes & Macros! Do Almost Everything! We have explained verity of examples to cover most frequently used codes.

Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see how to access the different Excel Object using VBA.

Built by PNRao — Trusted Since 2012