Posted 8 September 2017, 1:48 pm EST
I've a question about accessing the Spread object from another form. Let me explain.
I have 2 forms in my project
- Form 1: Main form with the Spread object with one Sheet: Testsheet
- Form 2: Popup form which will access the spread object.
When I access the public Spread from Form2 get the activesheet the Sheetname is Sheet1 instead of Testsheet.
Can anyone explain what I'm doing wrong?