1) You must edit your last post and wrap the code with the code tag.
[code]
VBA Code here
[/code]


No idea.

Just a guess
Do While Sheets("hello").Cells(11, colNo).Value <> Datev
    Sheets("hello").Cells(11, colNo).Value = Sheets("hello").Cells(11, colNo).Value * -1
colNo = colNo + 1
Loop