04 Buffer - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

Buffer property

Gets or sets a value in the buffer for specified field.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Field Variant Name or number of the field (column) containing the value to be returned.

Buffer procedures return or change values in a single row, reading or saving one row at a time. They are for use when rows are to be accessed randomly, and will be more efficient than processing each cell individually with Value, but if rows are to be read or written sequentially then the record level procedures (RecValue etc.) will be most efficient.