Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another simple error...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#VALUE Error should be simple fix | Excel Discussion (Misc queries) | |||
Fix Simple #Div/0! error | Excel Worksheet Functions | |||
Simple #DIV/0! error | Excel Worksheet Functions | |||
Cannot trace this simple error | Excel Programming | |||
Simple INT error? | Excel Programming |