Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. I want to compare the data in two different variables. I does not seem to
manage since one variable is encapsuled i.e. "55518" and the other is plain i.e. 55518. I have defined one of the variables as Variant but it does not help. Set rng1 = Worksheets("Indata").Cells.Find("Date", LookIn:=xlValues) If rng1 Is Nothing Then MsgBox ("Datum (date) kan ej hittas!") Else i = 0 Do Until IsEmpty(rng1.Offset(i + 1, 0)) = True If rng1.Offset(i + 1, 0).Value= startDatumArr(1) Then strTeststartDatumAddress = rng1.Offset(i + 1, 0) i = i + 1 Else i = i + 1 End If The problem is comparing rng1.Offset(i + 1, 0).Value with startDatumArr(1). The latter is defined as Variant. PLease any help is very much appreciated as well as needed!!!!!!!!!!!! The problem is comparing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing two columns of data and return unique data in another co | Excel Discussion (Misc queries) | |||
Comparing data between sheets, and copying rows with data | Excel Programming | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
Comparing data in two columns and highlighting the data | Excel Worksheet Functions |