Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using user defined constants
Hello:
when I run the following code Range A1 contaims "Name?" .What am I doing wrong ? Also in the for loop I would like to i to increment in steps of 0.1 how do i do that ? they way I tried does not work ?Thanks in advance Ravi Sub EnterInfo() Dim i As Double Dim x As Integer Dim y As Integer Dim del As Range Dim cel As Range Set cel = Range("a1") Set del = Range("b1") x = 2 y = 7 For i = 1 To 10 cel(i).Formula = "=SIN(x+y)" del(i).Value = i i = i + 0.1 Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wierd names defined as arrays of constants?!? | Excel Discussion (Misc queries) | |||
Wierd names defined as arrays of constants?!? | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Enumerated constants defined where? | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming |