Error '1004' in WorksheetFunction
 

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

--
oakma
-----------------------------------------------------------------------
oakman's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=31436

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