make range available to another macro
 

I have a procedure which sets a range to a variable:
Set copyrng = Range(HotStringStart, HotStringEnd)

The procedure then calls a separate macro, but the macro doesn't
recognize the range.

The range is available to the procedure it resides in but not to the
called macro. I am using the Public statement at the beginning of the
procedure

How can I allow copyrng to be used in the called macro. I am trying to
copy each cell in copyrng and write it to a text file.

Thanks...

make range available to another macro
 

Hi
Put the public declaration at the top of the code module

Public copyrng as Range

sub macro1()
'''
end sub

sub macro2()
'''end sub

etc

if both subs are in the same code module you can use Dim rather than
public too, but it still goes at the top of the module outside the
procedures.

regards
Paul


On Jun 18, 9:36*pm, Steve wrote:
I have a procedure which sets a range to a variable:
Set copyrng = Range(HotStringStart, HotStringEnd)

The procedure then calls a separate macro, but the macro doesn't
recognize the range.

The range is available to the procedure it resides in but not to the
called macro. I am using the Public statement at the beginning of the
procedure

How can I allow copyrng to be used in the called macro. I am trying to
copy each cell in copyrng and write it to a text file.

Thanks...

make range available to another macro
 

Thanks for the help, Paul.
Works good now...

---
Steve

On Jun 19, 5:10*am, wrote:
Hi
Put the public declaration at the top of the code module

Public copyrng as Range

sub macro1()
'''
end sub

sub macro2()
'''end sub

etc

if both subs are in the same code module you can use Dim rather than
public too, but it still goes at the top of the module outside the
procedures.

regards
Paul

On Jun 18, 9:36*pm, Steve wrote:

I have a procedure which sets a range to a variable:
Set copyrng = Range(HotStringStart, HotStringEnd)

The procedure then calls a separate macro, but the macro doesn't
recognize the range.

The range is available to the procedure it resides in but not to the
called macro. I am using the Public statement at the beginning of the
procedure

How can I allow copyrng to be used in the called macro. I am trying to
copy each cell in copyrng and write it to a text file.

Thanks...