+ Reply to Thread
Results 1 to 3 of 3

Clear Contents, Independent Instances; Same Worksheet VBA

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Clear Contents, Independent Instances; Same Worksheet VBA

    Hello I have need of VBA knowledge of which I know enough of to know that I know nothing.

    Currently I have found this VBA Macro to clear the contents of E2, if the content of E1 changes
    Please Login or Register  to view this content.
    I need to be able to do the same function on multiple other cells each with their own reference.

    ie: G1 to clear G2, I1 for I2 and so on,
    with various non-incremental addresses (if that matters)

    As always, any help would be greatly appreciated.
    Last edited by Entregan; 10-01-2018 at 07:23 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: Clear Contents, Independent Instances; Same Worksheet VBA

    Hi Entregan,

    To me it seems best to do:

    Please Login or Register  to view this content.
    There is no shorter route i think

  3. #3
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Re: Clear Contents, Independent Instances; Same Worksheet VBA

    Thank you, Joske920. I tried something like that before. However, I guess I had just entered it wrong. But, either way it works! Appreciate the help!

+ 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. Need VBA to Clear Contents of All Instances for Data Validation
    By SStreckfuss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2018, 01:49 PM
  2. [SOLVED] Clear Contents in an another worksheet
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2015, 02:21 AM
  3. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  4. [SOLVED] Clear Cell Contents on Worksheet Change
    By nickhunt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2015, 03:18 AM
  5. Independent SheetX.cells.clear command per sheet
    By paradoxofthecat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 04:43 AM
  6. [SOLVED] Clear Contents in Multiple WorkSheet
    By Allansdc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 12-18-2013, 10:32 AM
  7. Clear Contents of Cells On Another Worksheet
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2012, 05:27 PM

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