OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

getcellrangebyname is it possible to...

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Code Snippets
View previous topic :: View next topic  
Author Message
vinny2984
General User
General User


Joined: 27 Apr 2008
Posts: 19

PostPosted: Fri May 02, 2008 4:37 am    Post subject: getcellrangebyname is it possible to... Reply with quote

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?
thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Code Snippets All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group