<<Convert Excel Spreadsheets to Web Pages \| Trading Software That Operates Within Excel \| Convert Excel, Access & Other Databases \| Merge Excel Files>>

Excel Ranges: Special Cells, Naming Ranges, Offset & Referencing

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only ~~$145.00~~. $59.95 InstantBuy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE!

RANGES
Named Ranges. Sheet Level Named Range, Named Constants, Named Formulas ,Relative Named Ranges ,Dynamic Named Ranges ,Advanced Dynamic Named Ranges.
Working With Ranges. Find Last cell/row/column etc.
Formula Reference Changer. Absolute to Relative etc.
SpecialCells Method
Excel Named Range Manager $

OFFSET RANGES VBA
Returns a Range object that represents a range that�s offset from the specified range. Read-only.
expression.Offset(RowOffset, ColumnOffset)
"expression" is required and should be a Range object.

RowOffset: Optional Variant. The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.

ColumnOffset: Optional Variant. The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.

Example

Sub OffsetMe()   MsgBox Range("B2").Offset(RowOffset:=-1, ColumnOffset:=2).AddressEnd Sub

Is the SAME as;

Sub OffsetMe()   MsgBox Range("B2").Offset(-1,2).AddressEnd Sub

OFFSET FORMULA
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
Syntax = OFFSET(reference,rows,cols,height,width)
Examples
=OFFSET(C3,2,3,1,1) Displays the value in cell F5.
=OFFSET(C3:E5,0,-3,3,3) Returns an error, because the reference is not valid.

Instant Download and Money Back Guarantee on Most Software

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft