View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saladin Andreas[_2_] Saladin Andreas[_2_] is offline
external usenet poster
 
Posts: 6
Default reference with variables

range (e.g. for printarea selection) is normally noted like e.g.: "B2:S60"
Instead of the numbers I would like to use variables to replace numbers e.g.
integer variable.

It does not work to do it this way "B2:Sy"
nor this way "B2:S"y""

It seems that there has to be a letter and a number as reference

How to solve this?