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

ToHeader method

Converts a column to headers on change of value. Returns True if successful, otherwise False.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Field Variant Field name or number to convert to headers.

Converts a column to headers by inserting a row at each change of value and placing the new value in this row, with subsequent entries in the column blank until the next change. Normally the column would be narrow, giving a slightly indented effect.