Results 1 to 14 of 14

Looking to run a Private Sub Macro

Threaded View

potter185 Looking to run a Private Sub... 01-23-2014, 02:59 PM
6StringJazzer Re: Looking to run a Private... 01-23-2014, 03:37 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 03:37 PM
potter185 Re: Looking to run a Private... 01-23-2014, 03:42 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 03:48 PM
potter185 Re: Looking to run a Private... 01-23-2014, 03:48 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 03:55 PM
potter185 Re: Looking to run a Private... 01-23-2014, 03:56 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 04:11 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 04:12 PM
potter185 Re: Looking to run a Private... 01-23-2014, 04:35 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-23-2014, 04:41 PM
potter185 Re: Looking to run a Private... 01-23-2014, 05:03 PM
JOHN H. DAVIS Re: Looking to run a Private... 01-24-2014, 07:31 AM
  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Looking to run a Private Sub Macro

    Hi,

    I want to run a Private Sub Macro, the code is as below:

    Private Sub Worksheet_Change(ByVal Target As Range)
    
    Application.EnableEvents = False
    
    If Intersect(Target, Range("V2:V664")) Is "Os" And Intersect(Target, Range("AC2:AC664")) Is "Ach" Then
    
    Target.Value = "Movement from Os in '13 to Ach in '14"
    
    Application.EnableEvents = True
    
    End Sub
    This is basically required to compare values in 2 columns of a sheet with rows from 2 to 664 and based on the If loop if the condition is met then populate the target column with a specific statement.

    Can anyone please help me how to execute this macro

    Much appreciate the helper

    Regards

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Ruel #3 requires code tags. I have added them for you because you are a new user. --6StringJazzer
    Last edited by 6StringJazzer; 01-23-2014 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to run macro( Private sub)
    By var in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2012, 12:18 AM
  2. running a private sub macro
    By NALDO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2012, 06:44 PM
  3. [SOLVED] Calling a private macro
    By Nick Smith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2006, 09:20 AM
  4. [SOLVED] re : Possible to run private sub macros by writing another private
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2005, 12:05 AM
  5. [SOLVED] Private Sub Running Other Private Sub Inadvertently
    By Ross Culver in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2005, 09:06 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