.Find Issues

[Demni009]

Why do these return the same sum value? I thought .find was for total cell value and Cell Like "*5*" finds any cell with a 5 in it.

Set Psize = .Range(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0), Cells(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn))
Cells(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn + 1).Value = Application.Sum(Psize)

Set Psize2 = .Range(Header.Find("5" & ChrW(956)).Offset(rowi, 0), Cells(Header.Find("5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn))
Cells(Header.Find("5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn + 2).Value = Application.Sum(Psize2)

 

[MARK858]

I thought .find was for total cell value

Only if you explicitly state it as

lookat:=xlWhole

if you omit using

lookat:=xlWhole

or

lookat:=xlPart

then it will use whatever it was set as the last time find was ran (in this case xlPart).

Have a read of the link below for the parameter's of Find...

Range.Find Method (Excel)