Error '1004' in WorksheetFunction

  • Thread starter Thread starter oakman
  • Start date Start date
O

oakman

Hello Don,

Thank you for the help!
The macro runs smoothly, without any errors.
However, I have another question.
How would you capture data in column I?
You see, my contracts are in column E. My logic was that if I did
Vlookup Function, i could then set the result as the active cell.
Furthermore, I thought that I could set the range to be the active cel
plus 24 rows down. I could then copy this data to the desired sheet.
Unfortunately, I am not quite there. Therefore, I am thankful i
advance for any suggestions that are provided... Thankyo
 
You could use the same thing using MATCH on col I. OR,use vba FIND instead
 
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

Error '1004' in WorksheetFunction 1
Error 1004 3
Runtime error 1004 when trying to insert formula in cells 11
Error 1004 17
GoalSeek 1004 Error 5
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble 8
Run Time Error '1004' 1
Error message 1004 2

Back
Top