View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Error '1004' in WorksheetFunction

You could use the same thing using MATCH on col I. OR,use vba FIND instead

--
Don Guillett
SalesAid Software

"oakman" wrote in message
...

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 a
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 cell
plus 24 rows down. I could then copy this data to the desired sheet.
Unfortunately, I am not quite there. Therefore, I am thankful in
advance for any suggestions that are provided... Thankyou


--
oakman
------------------------------------------------------------------------
oakman's Profile:

http://www.excelforum.com/member.php...fo&userid=9172
View this thread: http://www.excelforum.com/showthread...hreadid=314369