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

ReadBuf method

Reads the requested row into the buffer. Returns True if successful, otherwise False.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Row Long Row number to be read.

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.