+ Reply to Thread
Results 1 to 2 of 2

Help in clearing content for only specific columns with VBA.

  1. #1
    Registered User
    Join Date
    09-11-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    67

    Help in clearing content for only specific columns with VBA.

    Hi Experts,
    I have a sheet with a long range (B5:KW14) and each time I have to clear the data manually.
    So I have to clear content from B5:H14 and the leave 2 column and aging Start clearing data from L5:L14 so on up to KP5:KW14.
    The twist here is after B5:H14, I do not want to clean Column I,J,K and then again start cleaning from L5:L14. I am actually stuck here. I have prepared a macro that clean from B5:KW14.

    So may I kindly ask you to help me here?

    S
    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,971

    Re: Help in clearing content for only specific columns with VBA.

    Please Login or Register  to view this content.
    Last edited by protonLeah; 03-21-2021 at 05:12 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to move specific content between columns
    By EverythingAllAtOnce in forum Excel General
    Replies: 4
    Last Post: 07-08-2020, 02:55 AM
  2. content clearing
    By achea in forum Excel General
    Replies: 3
    Last Post: 04-22-2019, 01:20 PM
  3. Content in a range is not clearing when i use F5 key
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2017, 02:03 AM
  4. [SOLVED] Clearing Sheet Content
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 02:09 PM
  5. Auto Clearing Content
    By sgris in forum Excel General
    Replies: 1
    Last Post: 12-05-2012, 01:31 AM
  6. clearing cell content on MAC?
    By themachine in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 08:39 AM
  7. macro help = extract content of specific columns accross a row
    By garyusenet@myway.com in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 07:55 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1