Thread
:
Error '1004' in WorksheetFunction
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]