Get the Column Count in a Worksheet Range

Get the number of columns in an Excel sheet.

This procedure is part of the Excel Book (BDK). To use this book, you must first learn it in your agent.

Input Concepts

Concept	Description	Type	Required
worksheet range	The reference to the Excel range.	excel range reference	Yes

Output Concepts

Concept	Description	Type
column count	The number of columns in the sheet range.	number

Examples

Get the number of columns in an Excel sheet.

get the sheet's used range
use the above as the range
get the column count in the range