+ Reply to Thread
Results 1 to 17 of 17

Move all rows 1 down but skip row 26 & Public Function IF problem

Hybrid View

  1. #1
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Move all rows 1 down but skip row 26 & Public Function IF problem

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Select Case Target.Address
        Case "$A$15", "$A$48", "$A$49", "$A$50"
              If CStr(Target.Value) = vbNullString then Target.Value = Date
       End Select
    End Sub
    Although, you may want to put the datestamp in the Double Click event rather then SelectionChange. Selection is vital to working a spreadsheet and changing cell's value when it is selected can be too volatile for my taste.
    Last edited by mikerickson; 01-26-2010 at 11:11 AM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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