Working With Worksheets

Add a Sheet

160

Delete a Sheet

162

Move a Sheet

164

Copy and Paste a Sheet 166

Hide a Sheet 168

Change the Name of a Sheet 170

Save a Sheet to Another File 172

Protect a Worksheet 174

Protect a Chart 176

Print a Sheet 178

Sort Worksheets by Name 180

11) DEFINING RANGES_

Using the Range Property 182

Using the Cells Property 184

Combine Multiple Ranges 186

Using the Offset Property 188

Delete a Range of Cells 190

Hide a Range of Cells 192

Specify the Name of a Range 194

Resize a Range 196

Insert a Range 198

Set the Width of Columns in a Range 200

Set the Height of Rows in a Range 202

Convert a Column of Text into Multiple Columns 204

Find the Intersection of Two Ranges 206

12) WORKING WITH CELLS _

Cut and Paste Ranges of Cells 208

Custom Paste Values in Cells 212

Add Comments to a Cell 214

Automatically Fill a Range of Cells 216

Copy a Range to Multiple Sheets 218

Place Borders Around a Range of Cells 220

Find Specific Cell Values 222

Find and Replace Values in Cells 224

13) CUSTOMIZING DIALOG BOXES, MENUS, AND TOOLBARS

UserForm Basics

Working with CommandBars

Create a Custom Dialog Box

Call a Custom Dialog Box from a Procedure ..

Capture Input from a Custom Dialog Box

Validate Input from a Dialog Box

Create Custom UserForm Controls

Create a UserForm Template

Create a Custom Toolbar

Add Controls to a Toolbar

Create a Custom Menu

Add Items to a Menu

Create a Shortcut Menu

Delete Custom Toolbars and Shortcut Menus .

.226 .228 .230 .232 .234 .238 .240 .242 .244 .246 .248 .250 .252 .254

0 0

Post a comment