Hello Ramthebuffs,
This should do it. You don't need to reassign the cell value in th
loop. You are only changing the format.
Code
-------------------
Dim c
Dim Rng As Range
Set rng = ActiveSheet.Range("C2:Q16")
For Each c In Rng
c.NumberFormat = "General"
Next c
-------------------
Sincerely,
Leith Ros
--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...fo&userid=1846
View this thread:
http://www.excelforum.com/showthread.php?threadid=48295