Another simple error...
What is your code supposed to do? I assume response is a variable? Where does
it come from and what type is it? It definitely will not run in its current
form, but until I know what it is intended to do I really can't help...
"Jim Berglund" wrote:
I created the following code, and get 1004 errors. Could you please explain why?
Sheets("Power Units").Activate
With ActiveSheet
.Range("A3:AV3").Select
.Selection.AutoFill Destination:=.Range(.Cells(4, 1), ..Cells((response - 2) * 0.4, 48)), Type:=xlFillDefault
Range(Cells(4, 1), Cells((response - 2) * 0.4, 48)).Select
Selection.Copy
End With
I've tried it with the "."'s all over, wihtout success. I guess I don't know why these errors occur - It seems a bit arbitrary when they occur.
Thanks in advance...
Jim Berglund
|