Poser votre question

Profil de Orlando - activité

2019-10-13 18:37:18 +0100 médaille reçue  Question célèbre (source)
2019-10-13 07:32:59 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-13 04:44:01 +0100 a répondu à une question Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet.getCellByPo

2019-10-13 04:42:43 +0100 a répondu à une question Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet.getCellByPo

2019-10-13 04:40:47 +0100 a modifié une réponse Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet

2019-10-13 04:39:53 +0100 a modifié une réponse Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet

2019-10-13 04:37:39 +0100 a modifié une réponse Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet

2019-10-13 04:36:46 +0100 a modifié une réponse Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet

2019-10-13 04:35:47 +0100 a modifié une réponse Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet

2019-10-13 04:34:48 +0100 a commenté une réponse Sorteio por fórmula sem repetir nomes de outra coluna

eu usei a linha de comando WAIT 0 na sua sugestão. . Muito obrigado pela colaboração!! :)

2019-10-13 04:30:13 +0100 marquée comme meilleure réponse Sorteio por fórmula sem repetir nomes de outra coluna

Olá, pessoal!

Pretendo adaptar as fórmulas existentes numa coluna E para o sorteio de nomes, desde que não repita nomes fixos em outra coluna G referente ao mesmo bairro. conforme planilha anexa:

Sorteio com fórmulas (atualizada)

Grato pela atenção!

Orlando Souza

8)

2019-10-13 04:29:48 +0100 a répondu à une question Sorteio por fórmula sem repetir nomes de outra coluna

Dim oSheet As Object oSheet = ThisComponent.CurrentController.ActiveSheet Dim oCell As Object oCell = oSheet.getCellByPo

2019-10-13 04:11:52 +0100 question commentée Do ... Loop - Finite Repeat Command

\ o / Perfect, @Mike Kaganski !!! Because my spreadsheet involves many columns with formulas, I had to include the WAIT

2019-10-12 19:03:39 +0100 médaille reçue  Question remarquable (source)
2019-10-12 18:49:45 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 18:44:05 +0100 question commentée Do ... Loop - Finite Repeat Command

You're right, @Opaque! I already updated the transported macro from my main spreadsheet. The file is used in various ver

2019-10-12 18:27:47 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 18:22:30 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 18:21:04 +0100 question commentée Do ... Loop - Finite Repeat Command

You're right, @Opaque! I already updated the transported macro from my main spreadsheet. Got it, @Mike Kaganski! I don'

2019-10-12 18:20:11 +0100 question commentée Do ... Loop - Finite Repeat Command

You're right, @Opaque! I already updated the transported macro from my main spreadsheet. Got it, @Mike Kaganski! I don'

2019-10-12 18:19:58 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 11:04:54 +0100 médaille reçue  Question populaire (source)
2019-10-12 09:16:23 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 09:02:23 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - Finite Repeat Command I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until" comma

2019-10-12 08:55:47 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - comando de repetição finita I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until"

2019-10-12 08:52:51 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - comando de repetição finita I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until"

2019-10-12 08:51:50 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - comando de repetição finita I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until"

2019-10-12 08:47:25 +0100 question modifiée Do ... Loop - Finite Repeat Command

Loop - comando de repetição finita I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until"

2019-10-12 08:46:06 +0100 a posé une question Do ... Loop - Finite Repeat Command

Loop - comando de repetição finita I don't know why the macro I recorded is giving error! I added the "Do .. Loop Until"

2019-10-10 19:58:35 +0100 a commenté une réponse Sorteio por fórmula sem repetir nomes de outra coluna

A sua sugestão ficou melhor, sem a planilha. . Realmente, o comando de repetição Do ... Loop não funciona no LibreOff

2019-10-10 19:53:28 +0100 a commenté une réponse Sorteio por fórmula sem repetir nomes de outra coluna

A sua sugestão ficou melhor, sem a planilha. . Realmente, o comando de repetição Do ... Loop não funciona no LibreOff

2019-10-10 19:52:58 +0100 a commenté une réponse Sorteio por fórmula sem repetir nomes de outra coluna

A sua sugestão ficou melhor, sem a planilha. . Realmente, o comando de repetição Do ... Loop não funciona no LibreOffi

2019-10-10 19:52:31 +0100 a commenté une réponse Sorteio por fórmula sem repetir nomes de outra coluna

A sua sugestão ficou melhor, sem a planilha. . Realmente, o comando de repetição Do ... Loop não funciona no LibreOffi