How would I output my specific times in column A starting wi

How would I output my specific times in column A starting with cell A3

Also Need to output y values in column C starting with C3

and X values column B starting at B3

Sub problem2()

Dim x0 As Integer, v0 As Integer, theta As Integer, g As Integer, t As Double, y0 As Integer Dim x As Double, y As Double

x0 = Range(\"F2\").Value

y0 = Range(\"F3\").Value

v0 = Range(\"F4\").Value

theta = Range(\"F5\").Value

g = -9.81

x = x0 + v0 * Cos(theta * (3.14159 / 180)) * t

y = y0 + v0 * Sin(theta * (3.14159 / 180)) * t + 0.5 * g * t ^ 2

Cells(2, 1) = 0

Cells(2, 2) = x

Cells(2, 3) = y

Do While (y > 0)

y = y0 + v0 * Sin(theta * (3.14159 / 180)) * t + (0.5 * g * t ^ 2) t = t + 0.1

If y > 0 Then x = x0 + v0 * Cos(theta * (3.14159 / 180)) * t

End If

Loop

End Sub

Solution

\'This syntax may help you to get the output in a specified range

\'The worksheet has a Range property which you can use to access cells in VBA.

ThisWorkbook.Worksheets(\"sheet1\").Range(\"A3\") = t

ThisWorkbook.Worksheets(\"sheet1\").Range(\"B3\") = x

ThisWorkbook.Worksheets(\"sheet1\").Range(\"C3\") = y

How would I output my specific times in column A starting with cell A3 Also Need to output y values in column C starting with C3 and X values column B starting

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site