View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default Public/Procedure Variable

Excel 2003, WinXP
I have a called sub:
Sub Test(TheCell as Range)
End Sub

This declares TheCell as a procedure variable. I want to declare TheCell as
a Public variable. If I declare TheCell As Range as Public at the top of
the module, how do I write the "Sub" line of this macro? Thanks for your
help. Otto