Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The range statement returns error 1004. Why?
Private Sub UpdateOnhand() Dim X As Integer Dim Y As Integer X = 0 Y = 0 Do Do Range("ONHAND").Offset(X, Y).Value = Range("ONHAND").Offset(X, Y).Value + Range("Received").Offset(X, Y).Value Y = Y + 1 Loop Until Y = 119 X = X + 1 Loop Until X = 7 End Sub -- Carl & Linda Brehm Lake Lafourche Bird House Hebert, LA Keets, Tiels, GN Lories, Quakers Mitred Conures, TAG's, Bourkes Cages --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.672 / Virus Database: 434 - Release Date: 04/28/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error 1004 (VBA) | Setting up and Configuration of Excel | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Error no. 1004 | Excel Programming |