Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone!
I have one old workbook and it contains following piece of code: Cells(6, Sel_C + 2) = "=" & VBA.Rnd() & "*" & Cells(5, Sel_C + 2).Address On my machine it works fine, but when I send this workbook to my colleague above mentioned line generates 1004 error. So I replaced previous code with following one: Cells(6, Sel_C + 2) = "=" & (Application.WorksheetFunction.RandBetween (0, 10000000) / 10000000) & "*" & Cells(5, Sel_C + 2).Address And now everything works fine. Does this all mean that my colleague does not have VBA library at all? Is it possible? Any thoughts? Thanks! Shahin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |