Hello,
How many columns spreadsheet has?
oExcel.ActiveWorkbook.ActiveSheet.Columns.Count returns number 256
but when I scroll spreadsheet horizontallyI see much more of them.
Roughly, my count is 27*27 which is equal to 729.
Why is that discrepancy?

Public Sub colcount()
Cells.Select
MsgBox Selection.Columns.Count
End Sub


--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Jack" wrote:
| Hello,
| How many columns spreadsheet has?
| oExcel.ActiveWorkbook.ActiveSheet.Columns.Count returns number 256
| but when I scroll spreadsheet horizontallyI see much more of them.
| Roughly, my count is 27*27 which is equal to 729.
| Why is that discrepancy?
|
|

"Jack" <replyto@newsgroup wrote in message
...
when I scroll spreadsheet horizontallyI see much more of them.
Roughly, my count is 27*27 which is equal to 729.

Not possible. There are only 256 columns. How do you get 27x27?

--

Vasant

Sorry my mistake.
I did not pay attention. The last column is IV not ZZ as I assumed.
I am not Excel user so I am not familiar with it.
What is the common way of addressing columns: number or letter?
What I mean is:
User will say: "Column 5" or "Column E" ?
Please advise.
Jack

"Jack" <replyto@newsgroup wrote in message
...
Hello,
How many columns spreadsheet has?
oExcel.ActiveWorkbook.ActiveSheet.Columns.Count returns number 256
but when I scroll spreadsheet horizontallyI see much more of them.
Roughly, my count is 27*27 which is equal to 729.
Why is that discrepancy?

Either way.

http://support.microsoft.com/default...;en-us;Q269866

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Jack" wrote:
| Sorry my mistake.
| I did not pay attention. The last column is IV not ZZ as I assumed.
| I am not Excel user so I am not familiar with it.
| What is the common way of addressing columns: number or letter?
| What I mean is:
| User will say: "Column 5" or "Column E" ?
| Please advise.
| Jack
|
| "Jack" <replyto@newsgroup wrote in message
| ...
| Hello,
| How many columns spreadsheet has?
| oExcel.ActiveWorkbook.ActiveSheet.Columns.Count returns number 256
| but when I scroll spreadsheet horizontallyI see much more of them.
| Roughly, my count is 27*27 which is equal to 729.
| Why is that discrepancy?
|
|
|
|