It is working fine now.
I wouldn’t have any idea how to define the variable CELL as you mention.
Perhaps my use of ‘define’ is misleading; the documentation refers to ‘declares’. In any case, it is probably useful to have at least a minimal knowledge of Basic if you are going to work with it; somewhat like at least knowing where to put the oil and water in your car.
Look at the source. Every Variable (places to store something) has a DIM-statement, giving its type (wich is needed to know, how much space to reserve). So the complicated part for you is to know wich type you need.
As you have a for each cell in source. you use the same type object as for the other “complex” things and come to an additional line below the other DIM-statements.
Dim cell as object
Especially somebody “messing around” should use option explicit because it can protect from typos like celll
.
Better: Learn to use a proper backup of your system, wich includes %APPDATA% wich is anbimportant folder in Windows. It will hold also bookmarks in Firefox, all downloaded emails in a regular setup for Thunderbird.
.
Manual copies of items of wich you know, because you already lost them once is a poor strategy for backups. It will fit in messing around…
.
PS: If you check for the safe-mode assistant you may find option to create a copy of your LibreOffice-profile, wich would include you macro-library (with exeption of macros stored in your files.)
FYI, I do have a regular backup of the user folder but whatever update in Libre Office that did this deleted it far enough back that the next backup replaced the Libre Office appdata with files after it had been deleted.
I think the last time I looked at the file was a month prior to realizing all my macros disappeared. Even then there’s a chance the macros were deleted before that because I do not always use the macros when I am working on the sheet.
Adding Dim cell as object is a little odd because before the macros got deleted by an update it worked fine without ever defining the “Cell” in this error.
Safe-mode assistant? I will look into that.
So you really can remember every line without understanding them? My guess is: If your memory is flawless you never had option explicit in your old code…
.
But with that kind of memory you should be able to restore your work without need of an backup. Speakingbof your backup:
So I’d say you have one copy of the folder somewhere. (Done manual?) Even on old standards this is no backup: If you computer dies when you do the copy you may loose/compromise both. Minimum would be two external copies wich are swapped as destnation for backup.
.
But in times, where hard-drives are cheap: Use a software with versioned backup. It will keep older versions of files. And (with exception of photo/video) nobody will fill a Terabyte-disk with self written data… There is plenty of space. (Photographers and video should be done separate.)
So you really can remember every line without understanding them? My guess is: If your memory is flawless you never had option explicit in your old code…
[/quote]
No, that code above worked exactly as it was written.
I have 3 drives that provide backup space. The free software I use doesn’t have version back ups and it has done great at backing up everything even if it overwrites it all. I use Syncback free.
Truth be told software updates should not delete things the user has created like macros or other things. In fact none of the other software I use deletes anything I created on any updates.
Putting it in NPP+ works just fine for mw. I have stuff in the NPP+ files from another program that’s no longer functional because it was more than 10 years ago (yes I really need to clean it out). My computer has crashed hard a few times in these years and it’s why I do the backups like I do. One crash completely closed off the C drive (issue with the drive manufacturer) but due to the way I do my backups I was up and running in no time, that is minus having to reinstall all the programs and their particular settings. Some might suggest setting up a disk image back up but there’s been quite a few times in the past where a disk image was also corrupted or it didn’t have all the files on it that I had just before the crash.
FYI, I had a complete power loss in my house right when I was doing a back up and there was no loss of data at all, even the time when I accidentally removed power from the PC during a different backup… Syncback runs silently in the background and I am always putting my system to sleep, but Syncback still manages to get all the backups done no matter what I do.