I did not write this code and am having trouble fixing it. Using column I and J if column J (10) is null then get value out of column 9 (I) otherwise if Column 10 (J) is not null then the the values from column J (10).
If Sheet1.Cells(row + 1, 10) = "" Then 'if J is null
INR = Sheet1.Cells(row, 9)
INR = Sheet1.Cells(row, 10) 'If J is not null then get value from J
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…