Using a variant in forumla... help please

Hi. I am trying to use a variant in a formula. Here's my code... do you know where I'm going wrong?

Please Login or Register  to view this content.

xx

well all you need to do is tell me where I'm going wrong with

Please Login or Register  to view this content.

surely...

Originally Posted by JosephP

you don't appear to be using a formula at all-they start with =
;-)

haha yes you're right... can't get that to work though if

Please Login or Register  to view this content.

then I get "#NAME?" in the cells do i need the &&&&& signs? x

Just a numeric value... at the moment it's "100". x

Merged cells not sure but perhaps

Please Login or Register  to view this content.

Alf

Originally Posted by Alf

Merged cells not sure but perhaps

Please Login or Register  to view this content.

Alf

Didn't exactly work, however

Please Login or Register  to view this content.

kind of did!.... Rather than "100" in the cells, I am getting "FALSE". But it's progress!
Thanks haha

Have you tried this as well?

Please Login or Register  to view this content.

Or perhaps you could do as patel45 suggested i.e. upload a sample file

Alf

Originally Posted by JosephP

no need for a formula then

Please Login or Register  to view this content.

Hi Joseph,
Thank you, this worked!
The problem is that I need tempset within a formula...
This is my code

Please Login or Register  to view this content.

I could not define tempset and just have
Cells(18, 2 * i + 3).MergeArea.Value = "=min('r13" & i + 57 & "'!R" & a & "C9:R" & r & "C9)-Plan!R42C4" maybe I'm making this harder than it needs to be...

xx