Thread: iterate through a row to find a match
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] suprmodl29@gmail.com is offline
external usenet poster
  
Posts: 4
Default iterate through a row to find a match
would anyone know why i am getting a run time error 1004
(application-defined or object-defined error) at this line:

If Worksheets("Table").Cells(productRow, StoreColumn).Value = _
Worksheets("Table").Cells(productRow, numSites + 2).Value Then

i seems right to me...

Reply With QuoteReply With Quote