Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.WorksheetFunction error | Excel Discussion (Misc queries) | |||
Excel 2003 WorksheetFunction Functions run-time error | Setting up and Configuration of Excel | |||
Worksheetfunction.vlookup and #value error | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Error '1004' in WorksheetFunction | Excel Programming |