Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence times (a positive whole number) from cells in sheet1 and use these values to highlight that number of cells in a row on sheet2. I understand about recording a macro and can highlight the cells in this manner. However, I cannot figure out how to take the value from one cell and use it on another one to highlight that number of cells. Anyone out there who can help?

What do you mean by "highlight" the cells? Do you want to select the cells or turn them a certain color or...?

Yes, turn the background a certain colour. Thanks for the reply.

Assuming a 6 in Sheet1!A1, this will fill Sheet2!A1:A6 with Green: Sub ColorRange() Sheets(2).Range(Cells(1, 1), Cells(1, Sheets(1).Range("A1"))).Interior.ColorIndex = 4 End Sub Hope that helps.

Excellent, this works. Thank you very much.