I am trying to read the value of "B2" in the worksheet named "Capture". The Value is coming from no where like the other cells which has list validations. It has just been typed.
When i do
Dim FileDate As String
FileDate = sheet1.Range("B2").Text
FileDate reads the value as Nothing.
Format cell type of B2 is Custom dd-mmm-yy
Sameway B3 is also Custom dd-mmm-yy
if i do
Dim AType As String
AType = sheet1.Range("B3").Text
AType reads RDTE (AEGIS)
Both are of same cell format type,Protected ot not why they behave differently?
I am attaching the file in Question
Revised 14AUG08 - Copy_ce723248.zip