M
my.wandering.mind
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
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