View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_16_] Steve[_16_] is offline
external usenet poster
 
Posts: 28
Default 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...