PDA

View Full Version : Solved: Delete select columns



av8tordude
02-27-2010, 03:14 PM
.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?

mbarron
02-27-2010, 03:33 PM
Just use two lines of code
.Range(Cells(Cur_Row, 3), Cells(Cur_Row, 5)).ClearContents
.Range(Cells(Cur_Row, 7), Cells(Cur_Row, 10)).ClearContents

av8tordude
02-27-2010, 03:41 PM
Thanks mbaron :beerchug: