Results 1 to 5 of 5

Macro not working excel 2016

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2018
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Macro not working excel 2016

    Hello,

    I have a code that I want to use
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Not Intersect(Target, Range("A6")) Is Nothing Then
            Range("A1:A5").Value = Range("A2:A6").Value
            Range("A6").Value = ""
        End If
    End Sub
    However when I put it int excel, the code will show up under my workbook or sheet, however it will not be found when I try to run it.

    I noticed that when I take away the text between () that it shows up but I need the (ByVal Target As Range) to work

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 02-05-2018 at 01:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add-in not working in Excel 2016
    By poultje in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2017, 07:11 AM
  2. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  3. 2010 Macro not working in 2016 Excel
    By porepiga in forum Excel General
    Replies: 7
    Last Post: 04-18-2017, 12:11 PM
  4. dlg macro not working on 2016
    By culebrasx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2016, 11:43 AM
  5. Replies: 0
    Last Post: 05-17-2016, 12:39 PM
  6. Macro From Excel 2013 Not Working in 2016
    By tm1238 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2016, 04:39 PM
  7. Excel 2016 15.17 on Mac - Controls not working
    By MRock in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-07-2016, 08:50 PM

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