Results 1 to 2 of 2

2 VBA macro's in correlation

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    2 VBA macro's in correlation

    hello everyone, i have 2 sheets i been working on, in my workbook which i have uploaded,

    one sheet is called "daily use" and the other sheet "daily use history" each of which has the same VBA code listed under, ( both 2 sheets have the same code )

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ARow As Integer
    If Target.Cells.Count > 1 Then Exit Sub
    On Error GoTo ErrHandler
    Application.EnableEvents = False
    ARow = ActiveCell.Row - 1
    With Target
     If .Column = 1 Or .Column = 3 Then
            ThisWorkbook.Sheets("daily use").Range(.Address).Value = .Value
            ThisWorkbook.Sheets("daily use history").Range(.Address).Value = .Value
    
        End If
    End With
    ErrHandler:
        Application.EnableEvents = True
    End Sub
    i was thinking, is it possible, to copy or rather cut the info in .column =3 from daily use to .column = 2 to daily use history ? ( without moving column 3 in daily use )
    Attached Files Attached Files
    Last edited by raffi123; 12-24-2013 at 04:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Correlation with a lag
    By simmo86 in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 02:15 PM
  2. Correlation
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 05-11-2011, 07:20 AM
  3. Asset Correlation Macro
    By jayk22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2009, 06:43 PM
  4. RSQ (Correlation)
    By John Bates in forum Excel General
    Replies: 5
    Last Post: 11-06-2009, 10:08 AM
  5. correlation help
    By ChrisBbacon in forum Excel General
    Replies: 1
    Last Post: 02-04-2007, 05:20 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