Hi There,

I am not so new to VBA in Excel but I will profess to be a noob when it comes to the R1C1 format in formulas.

The following lines have me stumped, because they only get part of the data I need. Can someone possibly interpret them for me please and let me know how to increase the amount of data each one takes from the origination locatio? I would be eternally grateful, as I can then tell the Division Chief that I was able, with some assistance from my friends, to successfully modify the macro for our personal use. Thank you to all who respond. Here is the code that has me cornfused
    Range("D2").FormulaR1C1 = "=IF(AND(MID(RC[-3],2,1)=""*"",MID(RC[-3],3,1)<>""*""),RC[-3],R[-1]C)"
    Range("E2").FormulaR1C1 = "=IF(AND(LEFT(RC[-4],1)=""*"",MID(RC[-4],2,1)<>""*""),RC[-4],R[-1]C)"
So, those are the lines that have been giving me fits since last week. I've tried debug.print statements, but just can't seem to figger this one out and was hoping one of ya'll could help.

Thanks again.

Hopelessly lost in Alabama