You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by QCIT3 MMisonora <mm...@outlook.com> on 2017/06/23 16:29:32 UTC
Macro Code Trrou
Hi there,
I just gotten the macros on a file that was originally from Excel to OpenOffice to appear and sometimes run. However, on one of the macros there is a mistake on one of my lines according OpenOffice and was hoping if someone can tell me how to fix it. The line says "LastSn = rng.Find("*", rng.Cells(1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False) .Row)"
Sent from Outlook<http://aka.ms/weboutlook>
Re: Macro Code Trrou
Posted by Hagar Delest <de...@gmail.com>.
FWD to OP (not subscribed).
Le 23/06/2017 à 21:39, James Plante a écrit :
> Everywhere there’s a comma, put a semicolon. That might fix it. Make it look like this:
>> LastSn = rng.Find(“*"; rng.Cells(1); Lookat:=xlPart; LookIn:=xlFormulas; SearchOrder:=xlByRows; SearchDirection:=xlPrevious; MatchCase:=False) .Row)
>> On Jun 23, 2017, at 11:29 AM, QCIT3 MMisonora <mm...@outlook.com> wrote:
>>
>> Hi there,
>>
>> I just gotten the macros on a file that was originally from Excel to OpenOffice to appear and sometimes run. However, on one of the macros there is a mistake on one of my lines according OpenOffice and was hoping if someone can tell me how to fix it. The line says "LastSn = rng.Find("*", rng.Cells(1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False) .Row)"
>>
>> Sent from Outlook<http://aka.ms/weboutlook>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Macro Code Trrou
Posted by James Plante <ji...@me.com>.
Everywhere there’s a comma, put a semicolon. That might fix it. Make it look like this:
> LastSn = rng.Find(“*"; rng.Cells(1); Lookat:=xlPart; LookIn:=xlFormulas; SearchOrder:=xlByRows; SearchDirection:=xlPrevious; MatchCase:=False) .Row)
> On Jun 23, 2017, at 11:29 AM, QCIT3 MMisonora <mm...@outlook.com> wrote:
>
> Hi there,
>
> I just gotten the macros on a file that was originally from Excel to OpenOffice to appear and sometimes run. However, on one of the macros there is a mistake on one of my lines according OpenOffice and was hoping if someone can tell me how to fix it. The line says "LastSn = rng.Find("*", rng.Cells(1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False) .Row)"
>
> Sent from Outlook<http://aka.ms/weboutlook>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org