dim mycell as range
for each mycell in range(Cells(1,2), cells(1,2).end(xldown)")
if mycell.value = "PY" then
"CODE HERE "
end if
next mycell
"Jeff" wrote:
I need help on an existing VBA formula:
In my spreadsheet €śConversion Validation Template Billable Jobs€ť row J3.
I want to do a vlookup on J3 that would look up the value in D3 in a
Table_Array spreadsheet €śVBAP€ť Col_Index_Num #3 IF AND ONLY IF the value in
rows of column B is: PY.
--
Regards,
Jeff
|