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

A little help to get cell address

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
dccwco
General User
General User


Joined: 22 Oct 2010
Posts: 5

PostPosted: Wed Nov 03, 2010 3:27 am    Post subject: A little help to get cell address Reply with quote

Hi to all of you,
I need a little help to create a macro to get the number of column and of row contained in a range selected by a fumntion.
Thank for your help
Back to top
View user's profile Send private message
B Marcelly
Super User
Super User


Joined: 12 May 2004
Posts: 1453
Location: France

PostPosted: Wed Nov 03, 2010 11:07 am    Post subject: Reply with quote

Hi,
Code:
MsgBox("Number of Columns " & myRange.Columns.Count)
MsgBox("Number of Rows " & myRange.Rows.Count)

_________________
Bernard

OpenOffice.org 1.1.5 fr / Apache OpenOffice 4.0.1 / LibreOffice 4.1.0
MS-Windows 7 Home SP1
This forum is spammed, use instead Apache OpenOffice forums
Back to top
View user's profile Send private message Visit poster's website
dccwco
General User
General User


Joined: 22 Oct 2010
Posts: 5

PostPosted: Wed Nov 03, 2010 11:13 am    Post subject: A little help to get cell address Reply with quote

Hi Bernard, I thank you a lot for your help. I will try at once your code.
Best regards
Back to top
View user's profile Send private message
dccwco
General User
General User


Joined: 22 Oct 2010
Posts: 5

PostPosted: Wed Nov 03, 2010 11:43 am    Post subject: A little help to get cell address Reply with quote

Dear Bernardo, I tried your code, but with my macros it don't works.
Are you so kind to write for me a complete macro (I am not a good writer of StarBasic macro).
I thank you a lot if you want help me; this problem is becoming an obsession for me, now.
Back to top
View user's profile Send private message
B Marcelly
Super User
Super User


Joined: 12 May 2004
Posts: 1453
Location: France

PostPosted: Wed Nov 03, 2010 11:17 pm    Post subject: Reply with quote

A complete macro is of no use for your problem if you don't have some knowledge of OpenOffice.org API to understand it.
Learn basics first. In the Basic Programming Guide or through forums or books.
_________________
Bernard

OpenOffice.org 1.1.5 fr / Apache OpenOffice 4.0.1 / LibreOffice 4.1.0
MS-Windows 7 Home SP1
This forum is spammed, use instead Apache OpenOffice forums
Back to top
View user's profile Send private message Visit poster's website
dccwco
General User
General User


Joined: 22 Oct 2010
Posts: 5

PostPosted: Thu Nov 04, 2010 12:37 am    Post subject: Reply with quote

Thanks Bernard, I will follow your suggestions.
Ciao
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 Macros and API 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