VBA Automation for Excel 2019 Cookbook

Table of Contents

Preface

Chapter 1: Getting Started with VBA

Technical requirements  18

Investigating VBA code  18

Getting ready  19

How to do it…  21

How it works…  22

There's more…  23

Recording a macro  23

Getting ready  23

How to do it…  24

How it works…  27

There's more…  28

Testing the macro  28

Getting ready  28

How to do it…  28

How it works…  30

There's more…  30

Using the VBA Editor  30

Getting ready  30

How to do it…  31

How it works…  31

There's more…  32

Editing the code by changing cell references  32

Getting ready  33

How to do it…  33

How it works…  35

There's more…  35

Saving the file with an embedded macro  35

Getting ready  35

How to do it…  35

How it works…  37

There's more…  37

Using the Trust Center for macro security  37 ...