Digitborn.com
Active Member
- Joined
- Apr 3, 2007
- Messages
- 353
Why this is not working?
Object required? Is there any other way to write it except:
Code:
With ws
Union(.Cells(lRow, 2).Value, .Cells(lRow, 3).Value, .Cells(lRow, 4).Value, .Cells(lRow, 5).Value, .Cells(lRow, 11).Value, .Cells(lRow, 12).Value, .Cells(lRow, 13).Value, .Cells(lRow, 14).Value, .Cells(lRow, 15).Value) = ""
End With
Code:
With ws
.Cells(lRow, 2).Value = ""
.Cells(lRow, 3).Value = ""
.Cells(lRow, 4).Value = ""
.Cells(lRow, 5).Value = ""
.Cells(lRow, 11).Value = ""
.Cells(lRow, 12).Value = ""
.Cells(lRow, 13).Value = ""
.Cells(lRow, 14).Value = ""
.Cells(lRow, 15).Value = ""
End With