C
Carrie_Loos via OfficeKB.com
I have a very large spreadsheet that loops through cells and updates them if
they are blank. I have a new conditon to add to that where if the cell is
blank and another is not blank then move to next cell. I'm a little stuck on
how to write that part. Can I put an "And" prior to the Then?
Dim mycell As Range
For Each mycell In Range("TO_Test")
If IsEmpty(mycell) Then
mycell = "something"
End If
Next mycell
they are blank. I have a new conditon to add to that where if the cell is
blank and another is not blank then move to next cell. I'm a little stuck on
how to write that part. Can I put an "And" prior to the Then?
Dim mycell As Range
For Each mycell In Range("TO_Test")
If IsEmpty(mycell) Then
mycell = "something"
End If
Next mycell