Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InsertLines Syntax
I want to add a variable to an inserted line, but I can't seem to get
the syntax right. I have for instance: With TempForm.CodeModule X = .CountOfLines Dim y for y = 1 to 10 .InsertLines X + y, "MsgBox ""This is message "" & y" next y End With The code is inserted into the module, but this is the result for each MsgBox: MsgBox "This is message " & y I just can't seem to get the variable to be part of the code. Any help will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem in InsertLines and CreateEventProc | Excel Programming | |||
VBA syntax | Excel Programming | |||
InsertLines crashes Excel | Excel Programming | |||
InsertLines crashes Excel | Excel Programming | |||
InsertLines and AddFromString crash excel | Excel Programming |