Thread: Concatenate a Const Name in Sub Routine
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
  
Posts: 471
Default Concatenate a Const Name in Sub Routine
Could you not just say:



If counter=1 then
left=10.1
elseif counter=2 then
left=20.1
....etc

or just
left=(counter*10)+.1



Reply With QuoteReply With Quote