+ Reply to Thread
Results 1 to 3 of 3

Clear Range with variable

  1. 05-08-2014, 12:50 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Clear Range with variable

    Hello:

    I need a simple VB Code to clear the cell :

    K106 = BI210:BU269


    Need to clear the range BI210:BU269

    if K106 = BI271:BU341 then need to clear range BI271:BU341

    Let me Know if you have any questions.
    Thanks.


    Riz
    Reply With QuoteRegister To Reply
  2. 05-08-2014, 12:53 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Clear Range with variable 

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 05-08-2014, 07:47 AM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Clear Range with variable

    Hello TMS:

    Great help, thanks

    Riz
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear Contents of a column in a range variable
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2014, 07:59 PM
  2. [SOLVED] Reset/clear variable completely - Comment problem
    By atomicsp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2013, 05:43 AM
  3. a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10
    By Capolan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  4. VBA clear entire row if corresponding cell in A has a variable set value
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2012, 12:05 PM
  5. [SOLVED] Copy/Paste Values from Variable Range to Corresponding Variable Range
    By Cpetersoc in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2012, 08:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1