dcsimg
Results 1 to 2 of 2
  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,019

    Resolved [RESOLVED] Excel: ClearContents below named range

    I have a named range consisting of 4 contiguous columns and I'd like to clear the contents of everything after row 5 of that range. I thought that Range("ABCD").Offset(-5, 0).ClearContents would work but I get the "Application-defined or object-defined error" error. What am I doing wrong?

  2. #2

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width


×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.