| View previous topic :: View next topic |
| Author |
Message |
dccwco General User

Joined: 22 Oct 2010 Posts: 5
|
Posted: Wed Nov 03, 2010 3:27 am Post subject: A little help to get cell address |
|
|
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 |
|
 |
B Marcelly Super User

Joined: 12 May 2004 Posts: 1414 Location: France
|
Posted: Wed Nov 03, 2010 11:07 am Post subject: |
|
|
Hi,
| Code: | MsgBox("Number of Columns " & myRange.Columns.Count)
MsgBox("Number of Rows " & myRange.Rows.Count)
|
_________________ Bernard
OpenOffice.org 1.1.5 fr / OpenOffice.org 3.4.1 en-US + langpacks, MS-Windows XP Home SP3
This forum is unusable, use instead Apache OpenOffice forums |
|
| Back to top |
|
 |
dccwco General User

Joined: 22 Oct 2010 Posts: 5
|
Posted: Wed Nov 03, 2010 11:13 am Post subject: A little help to get cell address |
|
|
Hi Bernard, I thank you a lot for your help. I will try at once your code.
Best regards |
|
| Back to top |
|
 |
dccwco General User

Joined: 22 Oct 2010 Posts: 5
|
Posted: Wed Nov 03, 2010 11:43 am Post subject: A little help to get cell address |
|
|
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 |
|
 |
B Marcelly Super User

Joined: 12 May 2004 Posts: 1414 Location: France
|
Posted: Wed Nov 03, 2010 11:17 pm Post subject: |
|
|
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 / OpenOffice.org 3.4.1 en-US + langpacks, MS-Windows XP Home SP3
This forum is unusable, use instead Apache OpenOffice forums |
|
| Back to top |
|
 |
dccwco General User

Joined: 22 Oct 2010 Posts: 5
|
Posted: Thu Nov 04, 2010 12:37 am Post subject: |
|
|
Thanks Bernard, I will follow your suggestions.
Ciao |
|
| Back to top |
|
 |
|