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 <mmiqc...@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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org