Do While Excel Macro for calculations in Hindi

Do While Excel Macro for calculations – Part 2 – Hindi.
Today we’ll use the do while Excel macro and complete the VAT and final amount calculations by referring to cells using the row and index numbers.
The code now looks like this:
Sub calculations()
Row = 3
Do While Cells(Row, 1) <> “”
Cells(Row, 4) = Cells(Row, 3) * Cells(Row, 2)
Cells(Row, 5) = Cells(Row, 4) * 0.125
Cells(Row, 6) = Cells(Row, 4) + Cells(Row, 5)
Row = Row + 1
Loop
End Sub

View the free Hindi training video.

Watch the Excel VBA training video on YouTube

Leave a Reply

Your email address will not be published. Required fields are marked *