Concatenating your Balls

did not work see here: where it did....
http://www.excelfox.com/forum/f17/ht...eet-test-1899/

I apply this code

Code:

---

Sub Evaluate_Left()Dim rngName As Range
Set rngName = ThisWorkbook.Worksheets("Sheet1").Range("A3:A10")
Dim rngEE As Range
Set rngEE = ThisWorkbook.Worksheets("sheet1").Range("E3:E10")
Let rngEE = Evaluate("if(row(3:10),LEFT(" & rngName.Address & ",4))")
End Sub 'Evaluate_Left()

---

and again get wot I expact....

see again...
http://www.excelfox.com/forum/f17/ht...eet-test-1899/

Now I apply this code

Code:

---

Sub Evaluate_VLOOKUP()Dim rngName As Range
Set rngName = ThisWorkbook.Worksheets("Sheet1").Range("A3:A10")
Dim rngCC As Range
Set rngCC = ThisWorkbook.Worksheets("sheet1").Range("C3:C10")
Let rngCC = Evaluate("if(row(3:10),VLOOKUP(" & rngName.Address & ",$A$16:$C$33,3,FALSE))")
End Sub 'Evaluate_VLOOKUP()

---

and get this:

see again:
http://www.excelfox.com/forum/f17/ht...eet-test-1899/


. I would have expected that result without The extra If Row() stuff, which I thought overcame this problem.
. can anyone suggest wot is going wrong, or how I obtain the correct results (Using the Evaluate Function for a range)
Thanks
Alan.


P.s. I can post a spreadsheet in the test area but not apparently here in a thread??. Can you help me on that one as well?

Hi DocAElstein, just as a pointer to your trouble with posting Html tables.
On vBulletin based forums there is a box in the bottom right corner that tells you what posting permissions can be used on each forum.
In this case HTML code is turned off.

http://i1371.photobucket.com/albums/...psd2f882ba.jpg

Quote:

---

Originally Posted by MARK858

Hi DocAElstein, just as a pointer to your trouble with posting Html tables.
On vBulletin based forums there is a box in the bottom right corner that tells you what posting permissions can be used on each forum.
In this case HTML code is turned off.

---

Thanks.
. Any idea how I can "turn it on"?
Alan

You can't, the Forum Admin decide and control what permissions are allowed in each forum.
In general in my experience it is quite general that if a forum allows attachments (like this one does) then HTML is switched off.

Quote:

---

Originally Posted by MARK858

You can't, the Forum Admin decide and control what permissions are allowed in each forum.
In general in my experience it is quite general that if a forum allows attachments (like this one does) then HTML is switched off.

---

OK.,
. I will look into the use of "attachments" next time!

Thanks
Alan