Software

Ask something
Discussion Locked

calculation in VB

0 helpful
3 replies

by fanku

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

ws.Cells(iRow, 24).Value = Me.basic.Value
ws.Cells(iRow, 25).Value = Me.hra.Value
ws.Cells(iRow, 26).Value = Me.conv.Value
ws.Cells(iRow, 27).Value = Me.others.Value
ws.Cells(iRow, 28).Value = Me.mf.Value
ws.Cells(iRow, 29).Value = Me.pf.Value
ws.Cells(iRow, 30).Value = Me.esic.Value

ws.Cells(iRow, 31).Value = Me.gross.Value

how can i calculate this gross automatically

3 replies

by unni_kcpm

Dear Mr.Fanku

Did you try using "sum" function ?

Self not sure. Possibly similar to below or
some changes needed.

by chandraram

Hi
I presume you mean the sum of columns 24 thru 27 as the gross... In this case, you can just put in a formula in ws.Cells(iRowm13). You will need to translate the column numbers to characters, though. For eg., 24=X, 25=Y and so on...

Hope this helps
Chandra

This discussion is closed to new replies.