| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To find number of non-empty cells across columns
Hi guys,
I regularly use the following code to count the number of occupied rows in a sheet: Sheets(1).Cells(Rows.Count, "A").End(xlUp).row I tried replacing ros with columns and A with 1 but it wont work for columns (i.e. count the number of non empty cells in row 1). Anyone know how to convert it into a column counter? Help much appreciated, kind regards, Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of columns on row that are not empty within a ran | Excel Discussion (Misc queries) | |||
| how to return non empty cells over several columns | Excel Discussion (Misc queries) | |||
| Filling in empty cells in columns | Excel Discussion (Misc queries) | |||
| Find empty cells | Excel Programming | |||
| Make all empty cells in columns = 0 | Excel Programming | |||
![Mark Stephens[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
