Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

Excel 2016 VBA and Macros [Pehme köide]

4.33/5 (45 hinnangut Goodreads-ist)

Bill Jelen, Tracy Syrstad

Formaat: Paperback / softback, 608 pages, kõrgus x laius x paksus: 230x180x30 mm, kaal: 975 g
Ilmumisaeg: 19-Nov-2015
Kirjastus: Que Corporation,U.S.
ISBN-10: 0789755858
ISBN-13: 9780789755858

Teised raamatud teemal:

Pehme köide
Hind: 42,61 €
Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
Kogus:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Lisa ostukorvi
Tasuta tarne
Tellimisaeg 2-4 nädalat
Lisa soovinimekirja

Formaat: Paperback / softback, 608 pages, kõrgus x laius x paksus: 230x180x30 mm, kaal: 975 g
Ilmumisaeg: 19-Nov-2015
Kirjastus: Que Corporation,U.S.
ISBN-10: 0789755858
ISBN-13: 9780789755858

Teised raamatud teemal:

Püsilink: https://www.kriso.ee/db/9780789755858.html

Märksõnad:

SAVE TIME AND SUPERCHARGE EXCEL 2016 WITH VBA AND MACROS!

Use Excel 2016 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues can understand and act on it…how to capture data from anywhere, and use it anywhere…how to automate Excel 2016’s most valuable new features. Mastering advanced Excel macros has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel.

Get started fast with Excel 2016 macro development
Write macros that use Excel 2016 enhancements, including Timelines and the latest pivot table models
Work efficiently with ranges, cells, and R1C1-style formulas
Build super-fast applications with arrays
Write Excel 2016 VBA code that works on older versions of Excel
Create custom dialog boxes to collect information from your users
Use error handling to make your macros more resilient
Use web queries and new web service functions to integrate data from anywhere
Master advanced techniques such as classes, collections, and custom functions
Build sophisticated data mining and business analysis applications
Read and write to both Access and SQL Server databases
Control other Office programs–and even control Windows itself
Start writing Excel Apps similar to those in the Excel App Store

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Dramatically increase your productivity–saving you 50 hours a year or more
Present proven, creative strategies for solving real-world problems
Show you how to get great results, no matter how much data you have
Help you avoid critical mistakes that even experienced users make

Introduction

(6)

What Is in This Book?

(3)

Reducing the Learning Curve

(1)

Excel VBA Power

(1)

Techie Stuff Needed to Produce Applications

(1)

Does This Book Teach Excel?

(2)

The Future of VBA and Windows Versions of Excel

(1)

Versions of Excel

(1)

Differences for Mac Users

(1)

Special Elements and Typographical Conventions

(1)

Code Files

(1)

Next Steps

(2)

1 Unleashing the Power of Excel with VBA

(26)

The Power of Excel

(1)

Barriers to Entry

(2)

The Macro Recorder Doesn't Work'

(1)

No One on the Excel Team Is Focused on the Macro Recorder

(1)

Visual Basic Is Not Like BASIC

(1)

Good News: Climbing the Learning Curve Is Easy

(1)

Great News: Excel with VBA Is Worth the Effort

(1)

Knowing Your Tools: The Developer Tab

(1)

Understanding Which File Types Allow Macros

(2)

Macro Security

(2)

Adding a Trusted Location

(1)

Using Macro Settings to Enable Macros in Workbooks Outside Trusted Locations

(1)

Using Disable All Macros with Notification

(1)

Overview of Recording, Storing, and Running a Macro

(2)

Filling Out the Record Macro Dialog

(1)

Running a Macro

(3)

Creating a Macro Button on the Ribbon

(1)

Creating a Macro Button on the Quick Access Toolbar

(1)

Assigning a Macro to a Form Control, Text Box, or Shape

(1)

Understanding the VB Editor

(2)

VB Editor Settings

(1)

The Project Explorer

(1)

The Properties Window

(1)

Understanding Shortcomings of the Macro Recorder

(12)

Recording the Macro

(1)

Examining Code in the Programming Window

(2)

Running the Macro on Another Day Produces Undesired Results

(1)

Possible Solution: Use Relative References When Recording

(4)

Never Use AutoSum or Quick Analysis While Recording a Macro

(1)

Four Tips for Using the Macro Recorder

(1)

Next Steps

(1)

2 This Sounds Like BASIC, So Why Doesn't It Look Familiar?

(26)

I Can't Understand This Code

(1)

Understanding the Parts of VBA "Speech"

(3)

VBA Is Not Really Hard

(2)

VBA Help Files: Using F1 to Find Anything

(1)

Using Help Topics

(1)

Examining Recorded Macro Code: Using the VB Editor and Help

(4)

Optional Parameters

(1)

Defined Constants

(3)

Properties Can Return Objects

(1)

Using Debugging Tools to Figure Out Recorded Code

(7)

Stepping Through Code

(2)

More Debugging Options: Breakpoints

(1)

Backing Up or Moving Forward in Code

(1)

Not Stepping Through Each Line of Code

(1)

Querying Anything While Stepping Through Code

(3)

Using a Watch to Set a Breakpoint

(1)

Using a Watch on an Object

(1)

Object Browser: The Ultimate Reference

(1)

Seven Tips for Cleaning Up Recorded Code

(6)

Tip 1: Don't Select Anything

(1)

Tip 2: Use Cells (2 , 5) Because It's More Convenient Than Range ("E2")

(1)

Tip 3: Use More Reliable Ways to Find the Last Row

(1)

Tip 4: Use Variables to Avoid Hard-Coding Rows and Formulas

(1)

Tip 5: Use R1C1 Formulas That Make Your Life Easier

(1)

Tip 6: Copy and Paste in a Single Statement

(1)

Tip 7: Use With... End With to Perform Multiple Actions

(3)

Next Steps

(2)

3 Referring to Ranges

(14)

The Range Object

(1)

Syntax for Specifying a Range

(1)

Named Ranges

(1)

Shortcut for Referencing Ranges

(1)

Referencing Ranges in Other Sheets

(1)

Referencing a Range Relative to Another Range

(1)

Using the Cells Property to Select a Range

(1)

Using the Offset Property to Refer to a Range

(2)

Using the Resize Property to Change the Size of a Range

(1)

Using the columns and Rows Properties to Specify a Range

(1)

Using the union Method to Join Multiple Ranges

(1)

Using the Intersect Method to Create a New Range from Overlapping Ranges

(1)

Using the IsEmpty Function to Check Whether a Cell Is Empty

(1)

Using the CurrentRegion Property to Select a Data Range

(2)

Using the Areas Collection to Return a Noncontiguous Range

(1)

Referencing Tables

(1)

Next Steps

(1)

4 Looping and Flow Control

(20)

For... Next Loops

(5)

Using Variables in the For Statement

(1)

Variations on the For... Next Loop

(1)

Exiting a Loop Early After a Condition Is Met

(1)

Nesting One Loop Inside Another Loop

(1)

Do Loops

(4)

Using the While or Until Clause in Do Loops

(1)

The VBA Loop: For Each

(4)

Object Variables

(3)

Flow Control: Using If... Then... Else and Select Case

(5)

Basic Flow Control: If... Then... Else

(2)

Using Select Case... End Select for Multiple Conditions

(3)

Next Steps

(2)

5 R1C1-Style Formulas

(10)

Referring to Cells: Al Versus R1C1 References

(1)

Toggling to R1C1-Style References

(1)

Witnessing the Miracle of Excel Formulas

(2)

Entering a Formula Once and Copying 1,000 Times

(1)

The Secret: It's Not That Amazing

(1)

Understanding the R1C1 Reference Style

(4)

Using R1C1 with Relative References

(1)

Using R1C1 with Absolute References

(1)

Using R1C1 with Mixed References

(1)

Referring to Entire Columns or Rows with R1C1 Style

(1)

Replacing Many Al Formulas with a Single R1C1 Formula

(2)

Remembering Column Numbers Associated with Column Letters

101

(1)

Using R1C1 Formulas with Array Formulas

101

(1)

Next Steps

102

(1)

6 Creating and Manipulating Names in VBA

103

(12)

Global Versus Local Names

103

(1)

Adding Names

104

(1)

Deleting Names

105

(1)

Adding Comments

106

(1)

Types of Names

106

(5)

Formulas

106

(1)

Strings

107

(1)

Numbers

108

(1)

Tables

109

(1)

Using Arrays in Names

109

(1)

Reserved Names

110

(1)

Hiding Names

111

(1)

Checking for the Existence of a Name

111

(3)

Next Steps

114

(1)

7 Event Programming

115

(16)

Levels of Events

115

(1)

Using Events

116

(1)

Event Parameters

116

(1)

Enabling Events

117

(1)

Workbook Events

117

(3)

Workbook-Level Sheet and Chart Events

119

(1)

Worksheet Events

120

(3)

Chart Events

123

(2)

Embedded Charts

123

(1)

Embedded Chart and Chart Sheet Events

124

(1)

Application-Level Events

125

(5)

Next Steps

130

(1)

8 Arrays

131

(8)

Declaring an Array

131

(1)

Declaring a Multidimensional Array

132

(1)

Filling an Array

133

(1)

Retrieving Data from an Array

134

(1)

Using Arrays to Speed Up Code

135

(1)

Using Dynamic Arrays

136

(1)

Passing an Array

137

(1)

Next Steps

138

(1)

9 Creating Classes and Collections

139

(18)

Inserting a Class Module

139

(1)

Trapping Application and Embedded Chart Events

140

(3)

Application Events

140

(1)

Embedded Chart Events

141

(2)

Creating a Custom Object

143

(2)

Using a Custom Object

145

(1)

Using Collections

145

(5)

Creating a Collection

146

(1)

Creating a Collection in a Standard Module

146

(2)

Creating a Collection in a Class Module

148

(2)

Using Dictionaries

150

(3)

Using User-Defined Types to Create Custom Properties

153

(3)

Next Steps

156

(1)

10 Userforms: An Introduction

157

(20)

Input Boxes

157

(1)

Message Boxes

158

(1)

Creating a Userform

158

(1)

Calling and Hiding a Userform

159

(1)

Programming Userforms

160

(2)

Userform Events

160

(2)

Programming Controls

162

(1)

Using Basic Form Controls

163

(11)

Using Labels, Text Boxes, and Command Buttons

163

(2)

Deciding Whether to Use List Boxes or Combo Boxes in Forms

165

(2)

Adding Option Buttons to a Userform

167

(2)

Adding Graphics to a Userform

169

(1)

Using a Spin Button on a Userform

170

(1)

Using the muitiPage Control to Combine Forms

171

(3)

Verifying Field Entry

174

(1)

Illegal Window Closing

174

(1)

Getting a Filename

175

(1)

Next Steps

176

(1)

11 Data Mining with Advanced Filter

177

(34)

Replacing a Loop with AutoFilter

177

(7)

Using AutoFilter Techniques

180

(3)

Selecting Visible Cells Only

183

(1)

Advanced Filter—Easier in VBA Than in Excel

184

(2)

Using the Excel Interface to Build an Advanced Filter

185

(1)

Using Advanced Filter to Extract a Unique List of Values

186

(6)

Extracting a Unique List of Values with the User Interface

186

(1)

Extracting a Unique List of Values with VBA Code

187

(4)

Getting Unique Combinations of Two or More Fields

191

(1)

Using Advanced Filter with Criteria Ranges

192

(9)

Joining Multiple Criteria with a Logical OR

193

(1)

Joining Two Criteria with a Logical AND

194

(1)

Other Slightly Complex Criteria Ranges

194

(1)

The Most Complex Criteria: Replacing the List of Values with a Condition Created as the Result of a Formula

194

(7)

Using Filter in Place in Advanced Filter

201

(2)

Catching No Records When Using a Filter in Place

202

(1)

Showing All Records After Running a Filter in Place

202

(1)

The Real Workhorse: xlFilterCopy with All Records Rather Than Unique Records Only

203

(7)

Copying All Columns

203

(1)

Copying a Subset of Columns and Reordering

204

(5)

Excel in Practice: Turning Off a Few Drop-downs in the AutoFilter

209

(1)

Next Steps

210

(1)

12 Using VBA to Create Pivot Tables

211

(40)

Understanding How Pivot Tables Evolved Over Various Excel Versions

211

(1)

While Building a Pivot Table in Excel VBA

212

(7)

Defining the Pivot Cache

212

(1)

Creating and Configuring the Pivot Table

213

(1)

Adding Fields to the Data Area

214

(2)

Learning Why You Cannot Move or Change Part of a Pivot Report

216

(1)

Determining the Size of a Finished Pivot Table to Convert the Pivot Table to Values

217

(2)

Using Advanced Pivot Table Features

219

(9)

Using Multiple Value Fields

220

(1)

Grouping Daily Dates to Months, Quarters, or Years

221

(1)

Changing the Calculation to Show Percentages

222

(3)

Eliminating Blank Cells in the Values Area

225

(1)

Controlling the Sort Order with AutoSort

225

(1)

Replicating the Report for Every Product

225

(3)

Filtering a Data Set

228

(14)

Manually Filtering Two or More Items in a Pivot Field

228

(1)

Using the Conceptual Filters

229

(4)

Using the Search Filter

233

(2)

Setting Up Slicers to Filter a Pivot Table

235

(4)

Setting Up a Timeline to Filter an Excel 2016 Pivot Table

239

(3)

Using the Data Model in Excel 2016

242

(5)

Adding Both Tables to the Data Model

242

(1)

Creating a Relationship Between the Two Tables

243

(1)

Defining the PivotCache and Building the Pivot Table

243

(1)

Adding Model Fields to the Pivot Table

244

(1)

Adding Numeric Fields to the Values Area

244

(1)

Putting It All Together

245

(2)

Using Other Pivot Table Features

247

(3)

Calculated Data Fields

247

(1)

Calculated Items

247

(1)

Using ShowDetail to Filter a Record Set

248

(1)

Changing the Layout from the Design Tab

248

(1)

Settings for the Report Layout

248

(1)

Suppressing Subtotals for Multiple Row Fields

249

(1)

Next Steps

250

(1)

13 Excel Power

251

(32)

File Operations

251

(4)

Listing Files in a Directory

251

(3)

Importing and Deleting a CSV File

254

(1)

Reading a Text File into Memory and Parsing

254

(1)

Combining and Separating Workbooks

255

(5)

Separating Worksheets into Workbooks

255

(1)

Combining Workbooks

256

(1)

Filtering and Copying Data to Separate Worksheets

257

(1)

Copying Data to Separate Worksheets Without Using Filter

258

(1)

Exporting Data to an XML File

259

(1)

Working with Cell Comments

260

(3)

Resizing Comments

260

(1)

Placing a Chart in a Comment

261

(2)

Selecting Cells

263

(5)

Using Conditional Formatting to Highlight the Selected Cell

263

(1)

Highlighting the Selected Cell Without Using Conditional Formatting

264

(1)

Selecting/Deselecting Noncontiguous Cells

265

(2)

Creating a Hidden Log File

267

(1)

Techniques for VBA Pros

268

(12)

Creating an Excel State Class Module

268

(2)

Drilling-Down a Pivot Table

270

(1)

Filtering an OLAP Pivot Table by a List of Items

271

(2)

Creating a Custom Sort Order

273

(1)

Creating a Cell Progress Indicator

274

(1)

Using a Protected Password Box

275

(2)

Changing Case

277

(2)

Selecting with SpecialCells

279

(1)

Resetting a Table's Format

279

(1)

Cool Applications

280

(2)

Getting Historical Stock/Fund Quotes

280

(1)

Using VBA Extensibility to Add Code to New Workbooks

281

(1)

Next Steps

282

(1)

14 Sample User-Defined Functions

283

(26)

Creating User-Defined Functions

283

(3)

Sharing UDFs

286

(1)

Useful Custom Excel Functions

286

(22)

Setting the Current Workbook's Name in a Cell

286

(1)

Setting the Current Workbook's Name and File Path in a Cell

287

(1)

Checking Whether a Workbook Is Open

287

(1)

Checking Whether a Sheet in an Open Workbook Exists

287

(1)

Counting the Number of Workbooks in a Directory

288

(1)

Retrieving the User ID

289

(2)

Retrieving Date and Time of Last Save

291

(1)

Retrieving Permanent Date and Time

291

(1)

Validating an Email Address

292

(1)

Summing Cells Based on Interior Color

293

(1)

Counting Unique Values

294

(1)

Removing Duplicates from a Range

295

(1)

Finding the First Nonzero-Length Cell in a Range

296

(1)

Substituting Multiple Characters

297

(1)

Retrieving Numbers from Mixed Text

298

(1)

Converting Week Number into Date

299

(1)

Extracting a Single Element from a Delimited String

300

(1)

Sorting and Concatenating

300

(2)

Sorting Numeric and Alpha Characters

302

(1)

Searching for a String Within Text

303

(1)

Reversing the Contents of a Cell

304

(1)

Returning the Addresses of Duplicate Max Values

304

(1)

Returning a Hyperlink Address

305

(1)

Returning the Column Letter of a Cell Address

306

(1)

Using Static Random

306

(1)

Using Select Case on a Worksheet

307

(1)

Next Steps

308

(1)

15 Creating Charts

309

(24)

Contrasting the Good and Bad VBA to Create Charts

309

(1)

Planning for More Charts to Break

310

(1)

Using .AddChart 2 to Create a Chart

311

(1)

Understanding Chart Styles

312

(3)

Formatting a Chart

315

(12)

Referring to a Specific Chart

315

(1)

Specifying a Chart Title

316

(1)

Applying a Chart Color

317

(1)

Filtering a Chart

318

(1)

Using SetElement to Emulate Changes from the Plus Icon

319

(5)

Using the Format Method to Micromanage Formatting Options

324

(1)

Changing an Object's Fill

325

(2)

Formatting Line Settings

327

(1)

Creating a Combo Chart

327

(3)

Exporting a Chart as a Graphic

330

(1)

Considering Backward Compatibility

331

(1)

Next Steps

331

(2)

16 Data Visualizations and Conditional Formatting

333

(22)

VBA Methods and Properties for Data Visualizations

334

(1)

Adding Data Bars to a Range

335

(4)

Adding Color Scales to a Range

339

(2)

Adding Icon Sets to a Range

341

(2)

Specifying an Icon Set

341

(2)

Specifying Ranges for Each Icon

343

(1)

Using Visualization Tricks

343

(4)

Creating an Icon Set for a Subset of a Range

344

(1)

Using Two Colors of Data Bars in a Range

345

(2)

Using Other Conditional Formatting Methods

347

(7)

Formatting Cells That Are Above or Below Average

348

(1)

Formatting Cells in the Top 10 or Bottom 5

348

(1)

Formatting Unique or Duplicate Cells

349

(1)

Formatting Cells Based on Their Value

350

(1)

Formatting Cells That Contain Text

351

(1)

Formatting Cells That Contain Dates

351

(1)

Formatting Cells That Contain Blanks or Errors

351

(1)

Using a Formula to Determine Which Cells to Format

352

(1)

Using the New NumberFormat Property

353

(1)

Next Steps

354

(1)

17 Dashboarding with Sparklines in Excel 2016

355

(20)

Creating Sparklines

356

(1)

Scaling Sparklines

357

(4)

Formatting Sparklines

361

(8)

Using Theme Colors

361

(3)

Using RGB Colors

364

(1)

Formatting Sparkline Elements

365

(3)

Formatting Win/Loss Charts

368

(1)

Creating a Dashboard

369

(5)

Observations About Sparklines

369

(1)

Creating Hundreds of Individual Sparklines in a Dashboard

370

(4)

Next Steps

374

(1)

18 Reading from and Writing to the Web

375

(16)

Getting Data from the Web

375

(6)

Building Multiple Queries with VBA

377

(1)

Finding Results from Retrieved Data

378

(1)

Putting It All Together

379

(1)

Examples of Scraping Websites Using Web Queries

380

(1)

Using Application. OnTime to Periodically Analyze Data

381

(4)

Using Ready Mode for Scheduled Procedures

381

(1)

Specifying a Window of Time for an Update

382

(1)

Canceling a Previously Scheduled Macro

382

(1)

Closing Excel Cancels All Pending Scheduled Macros

383

(1)

Scheduling a Macro to Run x Minutes in the Future

383

(1)

Scheduling a Verbal Reminder

383

(1)

Scheduling a Macro to Run Every Two Minutes

384

(1)

Publishing Data to a Web Page

385

(5)

Using VBA to Create Custom Web Pages

386

(1)

Using Excel as a Content Management System

387

(2)

Bonus: FTP from Excel

389

(1)

Next Steps

390

(1)

19 Text File Processing

391

(14)

Importing from Text Files

391

(11)

Importing Text Files with Fewer Than 1,048,576 Rows

391

(7)

Dealing with Text Files with More Than 1,048,576 Rows

398

(4)

Writing Text Files

402

(1)

Next Steps

403

(2)

20 Automating Word

405

(18)

Using Early Binding to Reference a Word Object

406

(2)

Using Late Binding to Reference a Word Object

408

(1)

Using the New Keyword to Reference a Word Application

409

(1)

Using the CreateObject Function to Create a New Instance of an Object

409

(1)

Using the GetObject Function to Reference an Existing Instance of Word

410

(1)

Using Constant Values

411

(2)

Using the Watches Window to Retrieve the Real Value of a Constant

411

(1)

Using the Object Browser to Retrieve the Real Value of a Constant

412

(1)

Understanding Word's Objects

413

(7)

The Document Object

413

(2)

The selection Object

415

(1)

The Range Object

416

(3)

Bookmarks

419

(1)

Controlling Form Fields in Word

420

(2)

Next Steps

422

(1)

21 Using Access as a Back End to Enhance Multiuser Access to Data

423

(16)

ADO Versus DAOs

424

(2)

The Tools of ADO

426

(1)

Adding a Record to a Database

427

(2)

Retrieving Records from a Database

429

(2)

Updating an Existing Record

431

(2)

Deleting Records via ADO

433

(1)

Summarizing Records via ADO

433

(1)

Other Utilities via ADO

434

(3)

Checking for the Existence of Tables

434

(1)

Checking for the Existence of a Field

435

(1)

Adding a Table On the Fly

436

(1)

Adding a Field On the Fly

436

(1)

SQL Server Examples

437

(1)

Next Steps

438

(1)

22 Advanced Userform Techniques

439

(24)

Using the UserForm Toolbar in the Design of Controls on Userforms

439

(1)

More Userform Controls

440

(7)

Checkbox Controls

440

(7)

Controls and Collections

447

(2)

Modeless Userforms

449

(1)

Using Hyperlinks in Userforms

449

(1)

Adding Controls at Runtime

450

(6)

Resizing the Userform On the Fly

452

(1)

Adding a Control On the Fly

452

(1)

Sizing On the Fly

452

(1)

Adding Other Controls

453

(1)

Adding an Image On the Fly

453

(1)

Putting It All Together

454

(2)

Adding Help to a Userform

456

(4)

Showing Accelerator Keys

456

(1)

Adding Control Tip Text

457

(1)

Creating the Tab Order

457

(1)

Coloring the Active Control

457

(3)

Creating Transparent Forms

460

(1)

Next Steps

461

(2)

23 The Windows Application Programming Interface (API)

463

(10)

Understanding an API Declaration

464

(1)

Using an API Declaration

465

(1)

Making 32-Bit- and 64-Bit-Compatible API Declarations

465

(2)

API Function Examples

467

(5)

Retrieving the Computer Name

467

(1)

Checking Whether an Excel File Is Open on a Network

467

(1)

Retrieving Display-Resolution Information

468

(1)

Customizing the About Dialog

469

(1)

Disabling the X for Closing a Userform

470

(1)

Creating a Running Timer

471

(1)

Playing Sounds

472

(1)

Next Steps

472

(1)

24 Handling Errors

473

(14)

What Happens When an Error Occurs?

473

(4)

A Misleading Debug Error in Userform Code

475

(2)

Basic Error Handling with the On Error GoTo Syntax

477

(1)

Generic Error Handlers

478

(3)

Handling Errors by Choosing to Ignore Them

479

(2)

Suppressing Excel Warnings

481

(1)

Encountering Errors on Purpose

481

(1)

Training Your Clients

481

(1)

Errors While Developing Versus Errors Months Later

482

(2)

Runtime Error 9: Subscript Out of Range

482

(1)

Runtime Error 1004: Method Range of Object Global Failed

483

(1)

The Ills of Protecting Code

484

(1)

Excel 2016 VBA and Macros [Pehme köide]

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad Ingliskeelsed raamatud

Vali ostukorv