Number of lines in a selection
Solved
Phil
-
Mytå Posted messages 4246 Registration date Status Contributeur Last intervention -
Mytå Posted messages 4246 Registration date Status Contributeur Last intervention -
Hello, I want to retrieve the result of a VBA procedure that:
1) selects a column
2) goes to the end of the column
3) example: Range("A12", [A12].End(xlDown)).Select
4) thank you
Configuration: Windows 7 / Internet Explorer 8.0
1) selects a column
2) goes to the end of the column
3) example: Range("A12", [A12].End(xlDown)).Select
4) thank you
Configuration: Windows 7 / Internet Explorer 8.0
5 réponses
Hello forum
To get the number of rows in a range of cells
And to get the number of columns in a range of cells
Mytå
Thank you for responding to your question, we are not robots...
Installed versions [MsProject 2003(FR), Excel 2003-2007(FR)]
To get the number of rows in a range of cells
Range("A12", [A12].End(xlDown)).Rows.Count And to get the number of columns in a range of cells
Range("A12", [A12].End(xlDown)).Columns.Count Mytå
Thank you for responding to your question, we are not robots...
Installed versions [MsProject 2003(FR), Excel 2003-2007(FR)]
