Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie stuck on Passing a Variable into a Range
Thanks Bob, I now see light at the end of the tunnel......just have to
climb through the train wreck:) Dave On Tue, 12 Aug 2003 21:52:16 -0400, "Bob Kilmer" wrote: Sub Main3() 'Minor variation on Main2 Index = 6 Set rng = Worksheets("Sheet1").Range("A1:D100") With rng .Columns(.Columns.Count).Cells(Index) = ComboBox.Value End With End Sub Sub Main4() 'Refers to cell Index in the last column of 'Worksheets("Sheet1").Range("A1:D100"). 'Does not use range variable. Index = 6 With Worksheets("Sheet1").Range("A1:D100") .Columns(.Columns.Count).Cells(Index) = ComboBox.Value End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Variable to LINEST | Excel Worksheet Functions | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Passing a variable to a range statement | Excel Programming | |||
Passing a value to a variable from Userform | Excel Programming |