Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range in FindMethod?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range in FindMethod?
It would only work if Tele is the activesheet when you do Set MyRange =
Range("DG5") sStr = "DG5" with worksheets("Tele").Range(sStr).CurrentRegion.Colum ns(1) It is unclear how the appropriate cell will be specified. -- Regards, Tom Ogilvy "CG Rosén" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |