Results 1 to 8 of 8

Clearing volatile cell ranges

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2009
    Location
    Phoenix, Arizona
    MS-Off Ver
    2003
    Posts
    7

    Clearing volatile cell ranges

    Hello, and thanks for taking the time to stop and read my help request.

    This is extremely difficult to explain due in part to my limited knowledge of excel, but I will try my best.

    I have an excel form where a user can insert a row of information and after insertion a macro automatically sorts the data into the rest of the dataset.

    I also have it set up so that before printing, all blank cells are hidden via autofilter.

    The problem is that after printing, I would like the option to clear one column of user entered data, but only among a certain range of rows.

    So, my question boils down to: How do I clear the range when I am unsure of how many rows there will be? (If this is even possible)

    I have uploaded a screenshot of the form to give some context. Please let me know if I should upload a sample work book, although I doubt it will be any good without having to explain how to use the form.

    Thanks in advance for your tips and words of wisdom!

    [edit] What I had thought about doing was something along these lines:
    Range("C4").Select
    Range(Selection, Selection.End(xlDown)).Select
    and then utilizing "Selection.Rows.Count" in some fashion to deselect the "Header" cell/row.
    Attached Images Attached Images
    Last edited by Quail; 04-21-2009 at 06:37 PM.

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