I am resending this as i didnt get it in my inbox and havent seen any replies so i assume it didnt get through the first time. G. -------------------------------------------- On Sat, 25/11/17, Gary Collins <[email protected]> wrote:
Subject: Accessing cells in macro To: "[email protected]" <[email protected]> Date: Saturday, 25 November, 2017, 12:10 Hi,I have a column in calc which contains strings of characters (actually representations of words in an ancient script) and in another column I will need to create a cipher for those words (in which each of the characters in a string is mapped to a specific different character) so that I can sort the rows into the customary "alphabetical" order for the script. I can write a macro to do this, but in order to do so I need to know how to access specific cells and cell ranges in the spreadsheet, and I'm not sure how to do this in calc (I've done it in excel, so the procedure should be similar). Can anyone help me out here, perhaps pointing me to some appropriate code snippets that address the issue? thanks,/Gary -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
