+ Reply to Thread
Results 1 to 4 of 4

Command Button - Clear

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    Command Button - Clear

    can i delete data (a1:b20) in sheet 1
    and data in (a1:b20) in sheet 2
    thru a command button

    actually i did try to do this as below. but this is giving me a
    "run time error 1004"
    "select method range class failed"

    any help on where i am going wrong

    Please Login or Register  to view this content.
    Last edited by grkchakri; 03-05-2012 at 12:39 AM.

  2. #2
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Command Button - Clear

    You will have to share the excel sheet over here. seems that those data cells are linked somewhere through formulae or Macros.

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

    Re: Command Button - Clear

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: Command Button - Clear

    Many Many Thanx ! it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1