Results 1 to 3 of 3

Adding a little procedure into a code

Threaded View

dimvelements13579 Adding a little procedure... 10-09-2012, 10:45 AM
DannyJ Re: Adding a little procedure... 10-09-2012, 10:48 AM
Norie Re: Adding a little procedure... 10-09-2012, 10:48 AM
  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    Brandenburg
    MS-Off Ver
    Excel 2003
    Posts
    4

    Adding a little procedure into a code

    I am trying to line-up a little code into a code I have before, but I don't get it; the code I try to put into the other one is this one.
    
    Sub Subtract_Row()
      Dim a
      Dim i As Long, j As Long, rws As Long
      
      With Range("E2", Range("L" & Rows.Count).End(xlUp)).Resize(, 21)
        a = .Value
        rws = UBound(a, 1)
        For i = 1 To rws
          For j = 1 To 6
            a(i, 15 + j) = Abs(a(1, j) - a(i, 8 + j))
          Next j
        Next i
        .Value = a
      End With
    End Sub
    and the big code (I call like that ) I am attaching my workbook.
    Attached Files Attached Files

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