Search results for query: *

Posted this to the MS Office Application Errors forum, but got no reply. Any help here at Tek-Tips would be greatly appreciated. Intermittent problem: My code (see below) results in a 4605 error message when called from a button click sub. The button click sub is run when a user clicks a...

Is there a way to copy code from one module to another using VBA code? For example, in Excel I'd like to create a new worksheet, then copy some custom functions to the worksheet object from a specific module within the VBA project. Thanks in advance.

I about around the bend on this one... I have a three-column table in one Word doc. The second and third columns cells are set to non-wrap. In my VBA code I dynamically load information from a spreadsheet into the various cells. In this table, when the second column expands beyond its...

The problem: vLookup successfully finds a value in another sheet, but when the return value is blank, the calling cell shows a zero. I've done everything--cleared the blanks cells, applied the text format option--that seemed obvious to me, but no luck. Some Google searches tell me that the...

I want to use Word VBA to select a range within an open spreadsheet. The simple code below points up the problem I'm having. Once the code hits the Range statement, I get a 1004 error. Everything else works fine. I believe my references are in order: Word VBA references XL5EN32.olb. Can...

I've been mulling this over for a day or two, and I'm just not experienced enough to get to an answer. I have a Word file with a series of tables in it that present product prices. Column 1 is the product name, column 2 is product code and column 3 is price. In addition, I have an Excel file...