The code above clears the contents from the selected row from column C-J. While the code works as expect, I would like it to exclude column F. Can anyone help?.Range(Cells(Cur_Row, 3), Cells(Cur_Row, 10)).ClearContents
The code above clears the contents from the selected row from column C-J. While the code works as expect, I would like it to exclude column F. Can anyone help?.Range(Cells(Cur_Row, 3), Cells(Cur_Row, 10)).ClearContents
Just use two lines of code
[VBA].Range(Cells(Cur_Row, 3), Cells(Cur_Row, 5)).ClearContents
.Range(Cells(Cur_Row, 7), Cells(Cur_Row, 10)).ClearContents[/VBA]
Thanks mbaron