Thread: Simple Macro to "Lookup - Repeat"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Simple Macro to "Lookup - Repeat"
replace
For Each cell In Sheets("A").Columns(5).Cells

with

For Each cell In Sheets("A").Range("E2:E10000").Cells
Reply With QuoteReply With Quote