Ask Your Question

Incrementing within strings for user defined function [closed]

asked 2013-08-12 20:50:55 +0100

salsacook gravatar image

I have a user defined function called


It is used to count all field with a certain background color.

Function countExcusedFields(oSheetName, oRange)
Dim oCellRange As Variant
Dim oSheet As Variant
oSheet = ThisComponent.getCurrentController().getActiveSheet()
oCellRange = oSheet.getCellRangeByName(oRange)

It work's pretty well, but as I give a string as argument value i have to problem that is wont auto increment B5:U5, B6U6 and so on. Is there any way to get LO to autoincrement a value within this string so I don't need to edit 300 rows by hand ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-06 07:35:23.795761

1 Answer

Sort by » oldest newest most voted

answered 2013-08-12 21:09:17 +0100

salsacook gravatar image

did the trick for me

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-12 20:50:55 +0100

Seen: 114 times

Last updated: Aug 12 '13