VBA newbie questions please

  • Thread starter Thread starter SUNIL
  • Start date Start date
S

SUNIL

column one is formated as Custom (dd-mm-yy) . On clicking in cell A8,
cell A8 reads 15-03-04 and formula bar reads "15/03/2004"
i want to use Set CK = Columns(1).Find(da) where da="15/03/2004"
Ck is Nothing ?
also tried CK = Columns(1).Find(da,,lookin=xlvalues)
but no joy.
Please help

Ta Suinl
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Date in an overseas format 20
Autofil on variable rows, delete extract and show remaining rows 3
search value not formula with .Find 1
VBA Programming: Cut and Paste Loop between 2 sheets 6
Dates 2
using the Find method in a VBA macro 1
FIND DATE xlLastRow and searchdirection 6
Compare dates in two worksheets 3

Back
Top