麻烦嵌套if ..然后在Excel 2010中循环

I apologize if this is an easy question, I just started macro programming yesterday and have not written in BASIC since qBasic (or any language for a while). I'm tring to read if a variable is equal to a specific value and, if so, write a different cell into a spreadsheet if it contains data. I keep getting an error of next without a for. It runs fine without the first if statement, can someone help me out? Bonus if you can help on writing the value rather than content, but I can figure that out without bothering you fine folks. Thanks for the help getting me to this point, this site has been invaluable. You'll probably recognize some of the coding.I apologize if this is an easy question, I just