Re: Macro Code Trrou

2017-06-24 Thread Hagar Delest
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;

Macro Code Trrou

2017-06-23 Thread QCIT3 MMisonora
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 =