Please help with my code

  • Thread starter Thread starter Guest
  • Start date Start date
Set rngToSearch = .Range(.Range("F2"), .Cells(Rows.Count, "F").End(xlUp))

Starts in F2 and looks at the bottom of column F (then upward) to find the last
used cell in column F.

But the code
For Each s2Record In rngToSearch
will look from F2 to F####
 
Good morning Dave,

Thank you very much again for taking the time to explain to me. I have
always learned a lot from you.

Happy Holiday!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Never ending ARRAY code problems 18
Modify working code to expand the output. 5
ERROR 400 on identical codes different range 8
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Code works but goes into endless loop and crashes 1
Transfer array element offset value to a matched value 3
Code copies twice...? 13
Run two macros for two different sheets 11

Back
Top