Reference Operators
now browsing by tag
AcroForms
add controls to form
Arbitration
Autoexpand
BookMarks
defined tables
Dynamic Hyperlinks
enable macros
Excel
Excel 1013
excel 2007
excel 2010
excel 2013
Excel Defined Names
Excel Linear Interpolation
Excel ScoreBoard
excel to pdf
excel userform
excel vba form
expand userform
Export XML Data From Excel
fill combo
Header Row
hide excel sheets
Mail Merge
Map Excel to Word
Mass Metters
PDF Form
pdf to excel
Ping Pong
protect sheet
range to array
Table Components
tables
Table Tennis
TextBox
TextBox Change Event
TextBox Exit Event
Totals Row
UDF
VBA Interpolate
vba user form
workbook protection
XFA Forms
XML Data
Excel Reference Operators
There are 3 Reference Operators in Excel:
- “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references, including the cells written in the reference text, like: A11:A13
- “,” (comma) is the Union operator, which combines multiple Ranges into one reference, like A11:A13 , A11:C11 , A11 (you can refer to simple cells too, not only to ranges with multiple cells)
- ” ” (space) is the Intersection operator, which returns a reference to the cell or to the range of cells found at the intersection of the ranges. In this example, only cell A11 is found in both ranges: A11:A13 A11:C11