How can i upload values of Non-Empty Cells Reference of a Table in ComboBox

gmayor · #1 03-08-2021, 04:53 AM

If you want the empty cells listing then

Code:

For i = 1 To .Cells.Count
            If Len(.Cells(i).Range) = 2 Then
                ComboBox1.AddItem .Cells(i).RowIndex & ", " & .Cells(i).ColumnIndex
            End If
Next i

SamDsouza · #2 03-08-2021, 10:00 PM

Thank you Sir,

What i take from your posts of this thread is that minimum length of Cell of Table is 2.
Any specific reason for MINIMUM Len of Cell of a Table = 2

Also I need to take care whenever i have to get Len of Text in a cell will always be as LEN(.Cell(1,1).Range.Text)- 2

This is RESOLVED

SamD

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to SUM the values only if the particular cells are not empty?	Learner7	Excel	3	11-10-2020 02:47 AM
auto progress number evenly between two values across empty cells ?	DBenz	Excel	4	03-28-2018 04:46 AM
If a2 is not empty, color empty cells in b2:af2	turkanet	Excel	2	08-20-2017 11:00 PM
Microsoft Excel 12.0 Object Library reference upload	chamdan	Project	2	04-21-2014 06:30 AM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM