Using VBA on a named range to replace select statement

[Tosca1978]

Hi all,

I am failry new to VBA so please bare with me.

I am using excel 2007 with a TM1 (an IBM product) add in.

I started off with the following code to select a adata upload sheet and perform a TM1Refresh which effectively send the numbers from the workksheet into TM1:

Please Login or Register  to view this content.

This works as it should. I then wanted to perform the same task with the Gabon Data Capture sheet hidden. Searching around the net and this forum I have worked out that you cannot use a select statement on a hidden sheet and that it is not recommended to use "Select" statments as they are inefficient.

Instead I have named the range of cells on the Gabon Data Sheet that I want to refresh "Gabon_Data". I ammended the code to reference the named range and drop the select statement. However, I cannot seemt to get the syntax correct:

Please Login or Register  to view this content.

I get an error message "Invalid use of property".

Please could someone explain where I am going wrong?

Many thanks

[JosephP]

are you sure that TM1Refresh will work with a hidden sheet? how would it know what range to use?