Im trying to do a row count with a vlookup so that only rows being used down
to the first space are in the vlookup. Here is the code that i have for just
the vlookup. So what im thinking is that i need to change

' Change this line
Set myR3 = Sheets("Modem").Range("Z2:Z4075")

' Change this line
myR3.FormulaR1C1 = "=VLOOKUP(RC[-24],MGICLPMI!R2C4:R621C14,11,0)"

myR3.Copy
myR3.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
myR3.Replace What:="#N/A", Replacement:="0", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

--
Message posted via http://www.officekb.com