Good Day,

I am having problem on highlighting rows based on my input in Exce
using VBA.

I do not know how to do this :

If my input(in sheet 1 ) is 8, then, i want VBA in excel to generate
rows highlighted in yellow automatically(in sheet 2).
There must be 2 blank rows which is separating each yellow line tha
has been generated.

Pls refer to my attachement if you don't understand my explanations
The one i did in the attachement is manually done.

Thank you

regards
Reen

Attachment filename: problem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55066
--
Message posted from http://www.ExcelForum.com