Now you've REALLY confused me
I can't see what you're trying to do - could you please attach an example workbook and label the cell you are trying to make do something, and describe what it is supposed to do.
I really would like to help you, but I just don't understand what you want!