Skip to Main Content
Computing with Excel and VBA
book

Computing with Excel and VBA

by S.I. Krishan
August 2008
Beginner to intermediate content levelBeginner to intermediate
298 pages
10h 49m
English
Jones & Bartlett Learning
Content preview from Computing with Excel and VBA
Chapter 3 More Excel50
area of a right angle triangle is more meaningful than the formula =C4*B5. Second,
the names are always treated as absolute references, which is convenient for tasks similar to
Exercise 3.1.
We will now look at how to use names for the triangle area exercise. We will do so by
using the Name box although Excel provides more than one method of assigning names
to cells. Let us first clear the contents of cells C5:F8. Next, we select cells B5:B8 that
show different base values. After that we click Name box, type the name that we want to
assign to cells B5:B8, and then press Enter. Generally, it is better to choose a name
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Programming with VBA Starter

Excel Programming with VBA Starter

Robert F Martin
Programming Excel with VBA and .NET

Programming Excel with VBA and .NET

Jeff Webb, Steve Saunders

Publisher Resources

ISBN: 9780763756680