OK - it looks like the EOF function will accomplish this.
Thanks
Search found 10 matches
- Thu Sep 19, 2024 5:08 pm
- Forum: BasicMaker NX and 2024 for Windows
- Topic: getting last row in spreadsheet
- Replies: 1
- Views: 1055
- Mon Sep 16, 2024 9:11 pm
- Forum: BasicMaker NX and 2024 for Windows
- Topic: getting last row in spreadsheet
- Replies: 1
- Views: 1055
getting last row in spreadsheet
Hi,
It would be nice to get the last populated row as a Planmaker range property. It could then be used as the upper bound in loops.
Thanks
It would be nice to get the last populated row as a Planmaker range property. It could then be used as the upper bound in loops.
Thanks
- Mon Sep 16, 2024 3:59 pm
- Forum: BasicMaker 2021 for Windows
- Topic: Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?
- Replies: 2
- Views: 21993
Re: Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?
I second this request - it would make BasicMaker more useful for programming Planmaker.
- Tue Sep 10, 2024 8:43 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: no decimals in csv export
- Replies: 3
- Views: 1642
Re: no decimals in csv export
Thank you for your help. The problem must have been with the file that I was exporting to csv. When I create numbers manually and export as csv it works fine.
- Thu Sep 05, 2024 10:20 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: no decimals in csv export
- Replies: 3
- Views: 1642
Re: no decimals in csv export
The decimals are exported when exporting with the default additional options csv export, but not when just .csv export is chosen.
- Thu Sep 05, 2024 8:39 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: no decimals in csv export
- Replies: 3
- Views: 1642
no decimals in csv export
With the latest update, a csv export does not export the decimals in numbers.
Planmaker 2024 S1218.0824 Windows 10
Planmaker 2024 S1218.0824 Windows 10
- Thu Jun 20, 2024 3:31 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Planmaker.bas error
- Replies: 3
- Views: 1958
Re: Planmaker.bas error
Thank you very much - that worked perfectly.
Bob
Bob
- Mon Jun 17, 2024 12:57 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Planmaker.bas error
- Replies: 3
- Views: 1958
Planmaker.bas error
Hi, I have Windows 10 and Softmaker Office 2024. When I run PlanMaker.bas I get this error message: "C:\Users\Bob\Documents\SoftMaker\Samples\PlanMaker.bas : Error in line: 17 - ActiveX component can't create object" Planmaker is already closed before I run the script. Am I doing something...
- Fri Jun 14, 2024 5:31 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Planmaker dark mode for sheets
- Replies: 1
- Views: 1429
Planmaker dark mode for sheets
Hi, I am using Softmaker Office 2004 on Windows 10, in which the dark mode has been selected in Windows settings. Textmaker and Presentations work areas are black. However Planmaker sheets are white and I would prefer them to be always black. I have looked everywhere in Options, User Interface etc. ...
- Thu Jun 13, 2024 1:24 pm
- Forum: SoftMaker Office NX and 2024 for Windows (General)
- Topic: Offline use
- Replies: 1
- Views: 1381
Offline use
Hi, Sorry, but I didn't find a definitive answer to this by searching. My main work computer with all of my data is no longer normally connected to the internet due to security concerns. After activating Softmaker Office 2024 using an internet connection, can I disconnect the work computer and conti...