CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 13 of 13

Threaded View

  1. December 19th, 2010, 12:26 AM #1
    firoz.raj
    firoz.raj is offline Member
    Join Date
    Dec 2008
    Location
    Step Into(F11)
    Posts
    465

    Question VBA Macro Issue In Excel Sheet

    I Simple Want Balance Needs to be (Total – Issuence).But it does not come properly in the Total Column !!!.let me know please .any help would be highly appreciated !!!.
    Code:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 7 Then
Target.Value = Target.Offset(0, -2) - Target.Offset(0, -1)
End If
End Sub

    Last edited by firoz.raj; December 19th, 2010 at 08:00 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured