SoftMaker.com

Didn't occur to me to exit the cell first. Thank you for the solution...

Yes, it is strange. I don't get any errors at any time. If I run the code from PlanMaker with the Run Script ribbon command, the spreadsheet blinks momentarily as if something happened, but nothing gets updated. I tried the Run Script command both from the ribbon and the quick launch toolbar. If I o...

Checked the results of running this code (modified with my cell addresses, of course), and it doesn't work. Specifically, the %v command does nothing when the script runs, but using the command manually works as expected.

Thanks for the help, SuperTech. So, I tried exactly what you suggested. Here's the result: If I step through the code (with the F8 key), execution stops on the "pm.Range("G2:G52").PasteSpecial" line, and gives "Error in line: 36 - Object doesn't support this property or meth...

Hmm...apparently there is no way to do a scripted Paste Special. I'm replicating a trailing stop tracking system for my stock portfolio (I have it set up and operating in MS Excel with VBA), and it absolutely requires the functionality of copying a column of cells and then pasting ONLY the values. I...

There is one scripting choice for this at present, the fixed scaling option percentage. I suggest adding scripting capability for the 4 Specify modes as well.

Page Setup -> Options -> Scaling Options -> Scaling Mode

I'm assuming that there is no script command for Freeze Cells (on the ribbon - View->Freeze Cells). If I'm just missing something, let me know...otherwise, this is a feature request to add this as a property.

When I use SendKeys, and I run the script using F8 to step through it, the SendKeys commands don't work. If I run the script using F9, the first instance works, the second doesn't do what's expected, and the third causes a system alert beep, otherwise does nothing at all. Here's the script: Sub Main...

Thanks for the reply, Miguel. Doing as you suggested works manually, but I can't find a search/replace script command. I'm looking in the BasicMaker 2018 manual...maybe that's the wrong place. Any suggestion where I'd find it?

I have a PlanMaker document that I'm converting from a .csv file, and some of the dollar amounts are in a string format...which PlanMaker can't read as values. Using the Value and Currency functions only results in a #VALUE! error. I've figured out a script to convert those amounts into usable value...