Thread: using alise
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OlieH OlieH is offline
external usenet poster
 
Posts: 39
Default using alise

to shorten code, I wish to declare
str = Workbooks(1).sheets(1).cells(RR,1)
as an alias so that each time I
need to reference that cell I could use an aliase
in stead of workbooks(1).sheets(1).cell(RR,1) = "a"
I could just use str = "a"

Thank you very much for any help.