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; MatchC
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 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("