Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Good Day, Code below works OK. The problem is that the Range has to be optional from DG5 DH5 DI5 DJ5 etc. Following seems not to work; Set MyRange = Range("DG5") With Sheets("tele").MyRange.CurrentRegion.Columns(1) Thanks for any hints. Brgds CG Rosén ---------------------------------------------------------------------- Dim c With Sheets("tele").Range("DG5").CurrentRegion.Columns( 1) Set c = .Find(ComboBox1.Text, LookIn:=xlValues) If c Is Nothing Then .Cells(.Rows.Count + 1).Value = ComboBox1.Text .Cells(.Rows.Count + 1).Offset(0, 1).Value = TextBox3.Text Else c.Offset(0, 1).Value = c.Offset(0, 1).Value + TextBox3.Text End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |