Not returning Text to Cell

[FranktheBank]

I'd thought I'd start a new thread as to separate my problems

I have the below:

Please Login or Register  to view this content.

Here's what '_AYZ81' looks like:

Please Login or Register  to view this content.

What it is supposed to do is, pending on input of 'VA_Loop' (1,2,7,8 or 9 (obtained from a UserForm)) put in a particular string in Sheet '_AYZ81' Column H, three rows down from last cell used.

It works for (1,2,8 or 9) but NOT 7, likely due to the nested IFs which needs it to take each line on '_AYZ81' and based on value in Column 'D' return the value.

ANY and ALL help is appreciated

[XOR LX]

Hi.

Please re-read the forum rules, particularly that one relating to "cross-posting".

Regards

[FranktheBank]

I guess this is a cross-post?? Here is my original:

http://www.mrexcel.com/forum/excel-q...text-cell.html