Results 1 to 2 of 2

change cell entry value after macro executed

Threaded View

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    change cell entry value after macro executed

    to avoid duplicating entries I wanted to remove the "marker" that controls it's inclusion in a macro (if a letter "m" is entered in column c:c, on filtering the range, associated data is transferred). Before exiting source workbook I wanted to remove all instances of "m" so next time they would excluded from the data transfer.

    However it would be preferable to leave a marker in the source sheet for future reference

    before exiting routine could the cell values in column c:c (if they equal "m") be changed to "mu" or something so that the marker remains but they will not be included in further filter occurances

    I had
    
    Range ("c:c").ClearContents
    rng.Autofilter
    End With
    End Sub
    as the end of my routine

    any pointers appreciated
    Last edited by nigelog; 05-31-2012 at 06:16 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