Wednesday, 7 December 2016

EXCEL MACRO TO SUBTRACT TWO COLUMN RANGE

Sub number()
finalrow = Sheets("Sheet1").Range("A10000").End(xlUp).Row
For j = 2 To finalrow
Value1 = Sheets("Sheet1").Range("A" & j).Value
Value2 = Sheets("Sheet1").Range("B" & j).Value
Sheets("Sheet1").Range("C" & j).Value = Value1 - Value2

Next j


End Sub 

No comments:

Post a Comment

Git

1 git add ↳ It lets you add changes from the working directory into the staging area 2 git commit ↳ It lets you save a snapshot of currently...