[Solved] conversion from vba to openoffice basic

[jaango123]

Hi All,

Please help me with the open office basic code from excel vba

iRow variable in vba contains the number of non empty rows count of Sheet1, column A.


What me doing in VBA is

1)Search if the cell in Column A sheet1 contains comma(,) using Instr function, then change the string, 's' as explained in the below line.

example P=lk,jk will change to P="lk,jk" and assigned to string s. Note:Chr(34) corresponds to ".


2)iterate the loop till end of the row and assign them to string s, after each iteration ", " to be added to the string, unless it is the last row.

3)Finally assign the string to worksheet2, first cell


Here is the vba code snippet

[patel]

try this

[JohnV]

[patel]

[JohnV]

Because creating the cursor by range didn't limit the last cell found to that range we can write a shorter version that does the same thing.

[jaango123]

Thanks guys. It worked.

[patel]

please add "[Solved]" to the beginning of your first post title (edit button).
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).