Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Range.Find issues... ? Do Dates Cause issues?

  Asked By: Kevin    Date: Nov 09    Category: MS Office    Views: 934
  

The what dTranDate, was originally a string from another worksheet...
both worksheets are formated as custom Dates...

either way I do this as a Date or String, it's not finding the date on
the new worksheet???



Set oBVCW_NEWCell =
oBVCW_NEWRange.Find(What:=dTranDate, LookIn:=xlValues) 'might get an
error with a string looking for a date... will see
If oBVCW_NEWCell Is Nothing Then
oBVCW_NEWCell(iRow, i1 + 1).Value = cADR
oBVCW_NEWCell(iRow, i1).Value = iRooms
End If


any ideas...

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Range.Find issues... ? Do Dates Cause issues? Or get search suggestion and latest updates.




Tagged: