Sorry for not being clear Richard. What I want is whenever the in any cell
in column A is =x, the macro should insert a row right above that row.

For example - if i enter x in A14, the macro should insert a row above. now
A14 will automatically become A15.

thanks in advance.

"Richard Buttrey" wrote in
message ...
On Fri, 18 Aug 2006 05:25:15 -0600, "Gary"
wrote:

i need a macro to do the following.

if value in cell is =x then insert a row above.

Possible?


Yes, but you need to give some more details as to how this is intended
to operate.

i.e. Are you referring to just a single cell such that when its value
changes to be greater than x, the row is inserted, or are you trying
to loop down a column of cells and wanting to insert several rows if
the condition is met?

If the former, do you want this to kick in once only, or every time x
is changed so that a row might be inserted several times if the
condition is met

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________