View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Patrick[_2_] Dave Patrick[_2_] is offline
external usenet poster
 
Posts: 25
Default Conflict reporting No of columns

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?
|
|
|
|