+ Reply to Thread
Results 1 to 3 of 3

Clear Content of conditional dynamic range

  1. #1
    Registered User
    Join Date
    08-01-2014
    Location
    Worcester, Massachusetts
    MS-Off Ver
    2010
    Posts
    3

    Clear Content of conditional dynamic range

    Hi everyone,

    I am currently working on writing a macro that clears all rows in which the cell in column F doesn't say "Sale", "Purchase", or "Tax Code Description", however, I keep receiving an error that says "Wrong number of arguments or invalid property assignment". Does anyone see the error in my code or have suggestions on how to fix it? Thank you!!

    Please Login or Register  to view this content.

    **also, I originally was deleting the rows, but I have formula's pulling from this tab and need them to not lose their reference after the macro executes
    Last edited by georgeofthejungle; 08-03-2014 at 12:17 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,043

    Re: Clear Content of conditional dynamic range

    Hi, georgeofthejungle,

    welcome to ExcelForum. Accrording to our Forum Rule #3 you would need to add code-tags to your procedure.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,043

    Re: Clear Content of conditional dynamic range

    Hi, georgeofthejungle,

    maybe alter the code-line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    as ClearContents doesn´t expect any further parameters opposed to Delete.

    ciao,
    Holger

+ 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] clear dynamic named range content
    By intex in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-12-2014, 08:29 AM
  2. [SOLVED] Clear Content if cell in a range contain #N/A VBA
    By alex_shin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 06:33 PM
  3. Dynamic Range for clear cells on change
    By Snickers65 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2013, 06:28 PM
  4. Clear content of range of cells if value is ""
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2013, 12:59 PM
  5. To clear content if conditional formatting cell return gray color
    By W.Patrick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2013, 01:00 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