Joined: 27 Apr 2008
|Posted: Fri May 02, 2008 4:37 am Post subject: getcellrangebyname is it possible to...
|using getcellrangebyname is it possible to select a range of cells on different rows which have other rows between them
a simple example of what i am trying to do is select a range of 20 cells as one contiuous range to apply a simple +1 value to the next in range
A1 to E1
A5 to E5
A9 to E9
A13 to E13
I've tried several variations of .....getcellrangebyname("A1:E1,A5:E5...... ) but not found one to work
or is there a better command to use?