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
Bookmarks