View number of columns from selected cells

[liloeconnie]

Hello to all of the forum,
I'm looking for a solution to a problem ...
When I select multiple cells horizontally at the top are highlighted columns for those cells.
I would need to know the number of those columns (es. 5), "on the fly", without having to rely on eye every time. This number maybe displayed in a status bar or other window...

Thanks in advance
Massimo

[Olly]

Put this in the worksheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = "Selected columns: " & Selection.Columns.Count
End Sub

Private Sub Worksheet_Deactivate()
Application.StatusBar = False
End Sub

[liloeconnie]

Hello, unfortunately I do not know the programming in Excel.
The code you write I understand what makes (approximately), the problem is that I do not know where to place it or how to make it perform better and also what to expect in terms of visualization.
The value for example where I show up?

What I need should be "interactive" we say, that when I select a number of cells, "on the fly" somewhere I immediately displays the number.

I would take steps so even step-by-step to run the code and get the result.

thanks
Massimo
*sorry for bad english

[Olly]

Right click the worksheet name, then click 'view code'. Paste my code in the worksheet module that appears.

The number of columns in the current selection will then be displayed in the statusbar, and will update every time your selection changes.

[liloeconnie]

Olly, It work fine!!!!
Very very well! Many thanks...

Massimo