Consulting

Results 1 to 3 of 3

Thread: Solved: Delete select columns

  1. #1

    Solved: Delete select columns

    .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?

  2. #2
    VBAX Mentor
    Joined
    Jun 2004
    Posts
    363
    Location
    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]

  3. #3
    Thanks mbaron

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •