+ Reply to Thread
Results 1 to 4 of 4

Want to change VBA to clear a certain range

  1. #1
    Registered User
    Join Date
    03-05-2021
    Location
    England
    MS-Off Ver
    Microsoft 365 (16.0.13801.20442)
    Posts
    11

    Want to change VBA to clear a certain range

    Hi there!

    Im currently making a form where a user can input data and it populates a table and it can be ammended and such, It also has a way to clear the contents of a data row im looking at, however I want to change the code so Im only clearing the selected row data between column D and S, Ive attached an image to show how the code currently is, many thanks for your help!

    VBA Code.PNG

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Want to change VBA to clear a certain range

    An image just means that we have to retype it - pasting the actual code is more useful, just FYI.

    Anyway, you could use:

    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    03-05-2021
    Location
    England
    MS-Off Ver
    Microsoft 365 (16.0.13801.20442)
    Posts
    11

    Re: Want to change VBA to clear a certain range

    Apologies, I'll keep that in mind for the future!

    But thank you, thats working a treat!

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Want to change VBA to clear a certain range

    Glad we could 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. [SOLVED] Error 1004 Method range of object when trying to clear range selection
    By shoulddt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2017, 10:09 PM
  2. Clear Cell range upon Changing data in difference Range
    By snuffnchess in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2016, 02:22 AM
  3. [SOLVED] If each cell in range equals 0 then clear contents of range and move to the next row
    By dagardner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2014, 08:44 PM
  4. [SOLVED] Macro to Clear contents in a range of cells when Date change.
    By aneshdas in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-08-2014, 01:53 AM
  5. 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
  6. Clear range based on cell value - clearing cells out of specified range
    By CADiphile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2013, 02:48 PM
  7. Replies: 1
    Last Post: 06-21-2013, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1