Hi,
Is there any function or any way by which i get to know that cell content is integer or Floting?
I need to findout in my VBA code if the cell content is floating if yes then truncate the contents to 6 decimal places
My vBA code is something like below
I want code to check that Cf1 and CF2 is float if yes
then trun cate to 6 decimal places like
cf1 = ws1.Cells(r, c).FormulaLocal
cf2 = ws2.Cells(r, c).FormulaLocal
If CF1 = Float ?
Then
Cf1=TRUNC(cf1,6)
CF2=TRUNC(cf2,6)
On Error GoTo 0
If cf1 <> cf2 Then
some action
Please help how to do that Iam stuck up with this
Many thanks,
Ankur
Bookmarks