ExcelBanter - Any body know how to count the cilumns in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Any body know how to count the cilumns in a range (https://www.excelbanter.com/excel-discussion-misc-queries/71275-any-body-know-how-count-cilumns-range.html)

Tom Weston

Any body know how to count the cilumns in a range

Hi
Does anybody know who to return the number of columns occupied by a range?

Hopefully Tom

Niek Otten

Any body know how to count the cilumns in a range

=COLUMNS(A1:Z20)

--
Kind regards,

Niek Otten

"Tom Weston" wrote in message
...
Hi
Does anybody know who to return the number of columns occupied by a range?

Hopefully Tom

All times are GMT +1. The time now is 11:11 PM.