Re: Help Me Make This Faster

2017-06-23 Thread toki
On 06/22/2017 07:22 PM, QCIT3 MMisonora wrote: > The computers we are using are Windows 7 computers that run on a Core 2 Duo > with 2 GB of RAM and a 32-bit Operating System. Your first problem is that you don't have enough RAM for the OS you are using. The second problem is that you don't have

Re: Macro Code Trrou

2017-06-23 Thread James Plante
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:

Re: Macro Troubles

2017-06-23 Thread Andrew Pitonyak
Trying to remember which will get me flamed less, top posting or bottom posting . Lets start with (2) because it is the easiest to answer. So, the answer is, I have no idea, it depends on what object Target is. Is this a Cell? A Range? If this is a SheetRange, then you should be able to use

Macro Troubles

2017-06-23 Thread QCIT3 MMisonora
Hi there, I have an excel file with macros on it and have gotten it onto OpenOffice, but the coding for the macros on the file keep saying there is an error, so I was wondering if anyone can please inform me as to how I can fix these two lines in two separate codes. 1. LastSn = rng.Find(

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 = rng.Find("

Re: Help Me Make This Faster

2017-06-23 Thread Johnny Rosenberg
2017-06-22 21:22 GMT+02:00 QCIT3 MMisonora : > > Hello there, > Recently the company I am working for has downloaded your program, > OpenOffice and have tried to open some files we have previously made files > on Windows Excel with your program. However, it took about twenty minutes > to load, so