I have a qustion abou VBA macros:
How can I access cells in VBA macro placed in  
[My macros and dialogs].basic (or other library)?

Macro below works if is placed in [TestFile.xls].VBAProject but does not
work in [My macros and dialogs].basic. The error message is :
BASIC 
runtime error. 
'35' 
cells

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1

Sub Test()
Cells(1, 1).Value = Time()
End Sub

Thank

--
View this message in context: 
http://nabble.documentfoundation.org/access-cells-object-in-macro-with-Option-VBASupport-1-tp2988791p2988791.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to [email protected]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to