Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Simple VBA I'm implementing into a spreadsheet and I have a few more columns to add but is this is the easiest or most efficient way to go about this?
VBA Code:
Sub FormulaMacro()
Worksheets("Data").Range("G10").Formula = "=((E10*100)/(100+F10)*100)/100"
Worksheets("Data").Range("G11").Formula = "=((E11*100)/(100+F11)*100)/100"
Worksheets("Data").Range("G12").Formula = "=((E12*100)/(100+F12)*100)/100"
Worksheets("Data").Range("J10").Formula = "=((H10*100)/(100+I10)*100)/100"
Worksheets("Data").Range("J11").Formula = "=((H11*100)/(100+I11)*100)/100"
Worksheets("Data").Range("J12").Formula = "=((H12*100)/(100+I12)*100)/100"
End Sub
Last edited: