Hi All,

I have a some data in a sheet from which I copy selected rows into new
sheets when specific criteria is met.

Now I would like add names to ranges that are present in these new
sheets The number of rows copied vary. How can I write a vba code that
can capture this?

Ex (in sheet 1 i have data starting from b4 to w12. In this I want to
name a range which starts from M5 to W12....
In sheet 2 I have a data which starts from b4 to w45. in this sheet I
want to name a range which starts from M5 to W45)

Hope my explanation is clear..
Any Suggestions

Thanks for your help
vishnu