Vishu

With ActiveCell

..EntireRow.Interior.ColorIndex = 6

End With


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 05:49:23 -0700, "vishu"
wrote:

Hi,
I have problem in macro codes.
I have recorded macro for rows formatting. For recording a macro I have
chosen line no.22.
After recording a macro I want to run this in line different rows, say for
example line no. 50. But whenever I run this It will go to line no.22 and
formatting.
How to change macro codes….I don’t want to give particular cell number in
macro codes.
I want to run this in different cells every time.
Please advise me…?

Regards,
Vishu