-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
.clear
-
D
What is the difference between .clear and .clearcontents?
What is the difference between .clear and .clearcontents? They sound like they do the same thing.- dpaton05
- Thread
- .clear .clearcontents difference sound thing
- Replies: 1
- Forum: Excel Questions
-
P
How to dynamically add values starting at a specific cell until the last row and add the contents to a combobox
The code below works, however, I would like the code to find and add all the items dynamically. Private Sub ComboBox1_Enter() If cmbSDPFLine.Value = "Line 1" Then With Me.ComboBox1 .Clear .List =...- Pookiemeister
- Thread
- .clear .list cmbsdpfline.value end me.combobox1
- Replies: 4
- Forum: Excel Questions
-
V
Evaluating Range for NULL or "" and replacing with .Clear
Programmers, My imported dataset has null values. Currently I loop through the columns and rows; and use this is code: IF .CELL(lRow, lCol).Value = "" THEN .CELL(lRow,lCol).Clear This method takes a long time. Could the .Range &/or Evalute method be used? Something like: With...- VenturSum
- Thread
- .clear evalute method null takes
- Replies: 12
- Forum: Excel Questions
-
M
ListBox population problem...
Hi, I'm using the following code to populate a ListBox: LR = Sheet2.Range("D" & Rows.Count).End(xlUp).Row With lbxTest .Clear For i = 1 To LR .AddItem Sheet2.Range("D" & i).Value Next i End With On occasions, column D of Sheet2 will be...- Matty
- Thread
- .additem .clear listbox population sheet2.ranged
- Replies: 3
- Forum: Excel Questions
