| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count colomns
Hi, Id like to know how to count in row "A1" how many cells contain
data. Eg a1,b1,c1,d1 etc. Blanks shoudnt be a problem as Im entering data in each col, so a blank cell would me the end of data entry anyway. Regards Robert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count colomns
for i = 1 to 10
cnt = application.CountA(columns(i)) msgbox "Col: " & i & " cnt: " & cnt Next -- Regards, Tom Ogilvy "RobcPettit" wrote: Hi, Id like to know how to count in row "A1" how many cells contain data. Eg a1,b1,c1,d1 etc. Blanks shoudnt be a problem as Im entering data in each col, so a blank cell would me the end of data entry anyway. Regards Robert |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count colomns
Thanks For your reply. Thats perfect.
Regards Robert Tom Ogilvy wrote: for i = 1 to 10 cnt = application.CountA(columns(i)) msgbox "Col: " & i & " cnt: " & cnt Next -- Regards, Tom Ogilvy "RobcPettit" wrote: Hi, Id like to know how to count in row "A1" how many cells contain data. Eg a1,b1,c1,d1 etc. Blanks shoudnt be a problem as Im entering data in each col, so a blank cell would me the end of data entry anyway. Regards Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete colomns and rows | Excel Worksheet Functions | |||
| colomns got swoeched | New Users to Excel | |||
| re-name colomns i.e A,B,C, etc | Excel Discussion (Misc queries) | |||
| how to merge 2 colomns | Excel Worksheet Functions | |||
| how to get more than 256 colomns in excel sheet ? | Excel Discussion (Misc queries) | |||
![RobcPettit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
