Results 1 to 6 of 6

Add a clear values code to command button

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2007
    Posts
    30

    Add a clear values code to command button

    I am using a command button to autopopulate one worksheet (named ranges) with values from another worksheet. (thanks to this forums help!).

    One slight problem. When i change the values in column b on "invoicing" worksheet, which designates which column in "cashflow" worksheet to put the data in, i am left with duplicate values. Data input into the originaly populated column and also the new data.

    All i need is a code to add to the command button that will clear all values in worksheet "cashflow", columns C:? first, then run the code required to populate and new information.

    For more information, please see my post http://www.excelforum.com/excel-prog...-criteria.html

    Please see sample file attached, and note that i have indicated particular ranges on the code that do not show on this attachment, as it is only a sampling of my file.
    Attached Files Attached Files
    Last edited by titantough; 06-14-2011 at 12:02 AM.

Thread Information

Users Browsing this Thread

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

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