VB code 'range' error when opening XL sheet from hyperlink

[baronvont]

Hi all.

Can anyong shed light on this problem. I have an XL sheet with the following code on a command button in the sheet:

Range("a1").Value = "hahahaha"

The same code is placed in a command buttton, but on a userform. Both work as expected.

However, I now hyperlink to the sheet from a web page, opening the sheet in an IE shell and the sheet command works but the form one throws up

Run-time error '1004'
Method 'Range' of object '_Global' failed

I'd be most greatful for any suggestions

Thanks
Georg

 

[SkipVought]

Hi,

Specify the sheet object explicitly...

 MySheet.Range("A1").Value = ....

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[baronvont]

as in worksheets(1).Range("a1").Value = "hahahaha" ??

Tried it already...that throws up

"Application-defined or object-defined error"

Georg

 

[SkipVought]

You may need to FULLY qualify...

application.workbook.worksheet.range....

"Application-defined or object-defined error" indicates the object is not properly quallified.


Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[baronvont]

OK got it...

Workbooks(1).Worksheets(1).Range("a1") = "hahaha"

This stuff will be the death of me one day

Thanks
for the help
Georg