+ Reply to Thread
Results 1 to 2 of 2

macro: combine / modify date / hilite

  1. #1
    nastech
    Guest

    macro: combine / modify date / hilite

    Have 2 scripts, not sure how to combine. Just tried line hilte script, would
    like to see if there is a way to use border hilite (top & bottom; shade
    looking for would have been to not change colors, but idea works..) for line,
    so colors not changed, otherwise to combine: (thanks)

    XXXXXXXXXXXXXXXXXXXXXXXXXXXX
    Other Code, check for hiliting line:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static mRow As Long
    If mRow <> 0 Then
    Rows(mRow).Interior.ColorIndex = xlNone
    End If
    mRow = Target.Row
    Rows(mRow).Interior.ColorIndex = 22
    End Sub

    XXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    With Target
    If .Count > 1 Then Exit Sub
    If Target.Row < 91 Then Exit Sub
    If Me.Cells(.Row, "A").Value = "." Then Exit Sub
    If Not Intersect(Me.Range("AV:AW"), .Cells) Is Nothing Then
    Application.EnableEvents = False
    With Me.Cells(.Row, "BC")
    .NumberFormat = "dd"
    .Value = Now
    End With
    Application.EnableEvents = True
    End If
    End With
    End Sub

  2. #2
    nastech
    Guest

    RE: macro: combine / modify date / hilite

    p.s.: saw different script that included the following line, but rest of
    that script (not included here, wiped color from rest of document). might
    use this color / variation? thanks

    Target.Rows.EntireRow.Interior.Color = vbYellow



+ Reply to Thread

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