1. How do I clear out a range of data that starts at B4 and goes down
the column...how would I put this in a loop?

' Clear column B starting at B4 ....
.Range("b4:b" & .Cells(Rows.Count,
"B").End(xlUp).Row).ClearContents

2. How do I copy (paste special) a cell on a worksheet and run it
through a loop to populate the rest of some cells?
Example: I11 = vlookup....... -- but displays RW1111
I want to copy that to E9 and down the rest of the column to correspond
to some other data I have there, but I can't get it to copy the
RW1111...it keeps coming up with a zero due to the vlookup I
suppose....any help?