Thanks , it works .

Strangely but i put the question here : 'Discussion Groups Home'
(http://tinyurl.com/y7jug7)

Gave a search with google and found this forum with my question . And a
answer for it Bg:)

I came across another problem . Sometimes i have :

Code
Product
Price
Some empty cells
Code
Product
Price
Some empty cells
CODE
PRICE
Some empty cells
Code
Product
Price

So , between Code and price i need a macro to put "unknown product" .
Something like it reades the cell with "price" keyword . Goes one cell
above . If there finds "product" , it's OK . If finds else , creates a
new empty row and puts "unknown product " in cell above the cell with
"price" .

Should be something like this :

Code
Unknown product
Price


--
andrei
------------------------------------------------------------------------
andrei's Profile: http://www.thecodecage.com/forumz/me...hp?userid=1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145279