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

Reply via email to