- #1
dmatador
- 120
- 1
This is my first attempt at writing a VBA program. I am just trying to square items in excel in column 'A' and output the answer to column 'B'.
Option Explicit
Sub timestimes()
Dim n As Integer
Dim i As Integer
Dim z As Integer
n = Range("A").Count
For i = 1 To n
z = Range("A").Cells(i).Value
Range("B").Cells(i).Value = z * z * z
Next i
End Sub
It's giving me the previously noted runtime error along with the message Method 'Range' of object '_global' failed. I am clueless as to how to fix this problem since I know very very little about the language and working with excel like this. Any suggestions?
Option Explicit
Sub timestimes()
Dim n As Integer
Dim i As Integer
Dim z As Integer
n = Range("A").Count
For i = 1 To n
z = Range("A").Cells(i).Value
Range("B").Cells(i).Value = z * z * z
Next i
End Sub
It's giving me the previously noted runtime error along with the message Method 'Range' of object '_global' failed. I am clueless as to how to fix this problem since I know very very little about the language and working with excel like this. Any suggestions?