F
fi.or.jp.de
Hi All,
Is there any option to declare a range publicly.
I have more than 10 to 15 modules
I need to set the Rng as Range
i.e., set Rng = sheets("Sheet1").Range("A:A")
set Rng1 = Sheets("sheet1").Range("K:K")
.....So on..
I have to do, in each module i need to set the Rng or Rng1 or Rng2
etc....
Can i public declare or set the Ranges. so that I can use in any
module.
Please let me know, how can i achieve this.
Thanks in advance.
Is there any option to declare a range publicly.
I have more than 10 to 15 modules
I need to set the Rng as Range
i.e., set Rng = sheets("Sheet1").Range("A:A")
set Rng1 = Sheets("sheet1").Range("K:K")
.....So on..
I have to do, in each module i need to set the Rng or Rng1 or Rng2
etc....
Can i public declare or set the Ranges. so that I can use in any
module.
Please let me know, how can i achieve this.
Thanks in advance.