View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ndjxw17@yahoo.co.uk is offline
external usenet poster
 
Posts: 4
Default setting object variable

i am looking for some advice on object variables. I have a module with
two sub routines in it. i have the following object variables at
module level

dim codes as worksheets

i want to use this variable in both subs, and the value(worksheet) will
be the same, so do i have to set the variable in both subs,
set codes = worksheets("sheet1)
this is what i am doing at the moment but i am not sure if this is
correct or good programming.

regards
chris