Results 1 to 10 of 26

Thread: Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-10-2020, 01:28 PM #1
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    Large column count is being .Cleared Contents of is
    LngColumnTooLong.JPG : https://imgur.com/SujMF73
    LngColumnTooLong.jpg

    So..
    Try is maybe only want 2 columns to be .Cleared Contents of is

    So change
    Code:
            .Range("M1").Resize(lngRow - 1, lngCol - 1).ClearContents
    to
    Code:
            .Range("M1").Resize(lngRow - 1, 2).ClearContents
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Class Stuff: VBA Custom Classes & Objects, Class Modules
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 29
    Last Post: 06-02-2024, 01:49 PM
  2. VBA referring to external shared Libraries, 1) Early, 1.5) Laterly Early and 2) Late Binding Techniques
    By DocAElstein in forum Familiar with Commands and Formulas
    Replies: 9
    Last Post: 05-13-2021, 02:31 PM
  3. Removed highlighted colour based on condition Leonardo1234 rider@1234
    By rider@1234 in forum Excel Help
    Replies: 2
    Last Post: 06-23-2019, 03:30 PM
  4. VBA Range.Sort with arrays. Alternative for simple use.
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 23
    Last Post: 04-22-2019, 12:31 PM
  5. Free And Simple Excel Based Gantt Chart
    By Excel Fox in forum Download Center
    Replies: 0
    Last Post: 05-02-2013, 03:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules