実行したマクロはこんな感じっす＞＜

# -*- coding: utf-8 -*-
def a1():
doc = XSCRIPTCONTEXT.getDocument()
sheet = doc.getSheets().getByName('Sheet1')
A1 = sheet.getCellRangeByName('A1')
A1.Value = 777