| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Integrate a Vlookup function in to a macro
I have no clue how to add this vlookup function to a macro.
The formula is =VLOOKUP(A6,'[Commissions Master Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE) Its working great if I keep copy pasting the formula but I want to take it a step ahead and automate it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Integrate a Vlookup function in to a macro
Try recording a macro when you enter it and then take a look at the result.
"Arain" wrote: I have no clue how to add this vlookup function to a macro. The formula is =VLOOKUP(A6,'[Commissions Master Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE) Its working great if I keep copy pasting the formula but I want to take it a step ahead and automate it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Integrate a Vlookup function in to a macro
On Apr 12, 6:16 pm, Arain wrote:
I have no clue how to add this vlookup function to a macro. The formula is =VLOOKUP(A6,'[Commissions Master Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE) Its working great if I keep copy pasting the formula but I want to take it a step ahead and automate it. Part of the recording of your macro should be typing vlookup formula. It will work.. I've done it many time myself. When you run your macro, make sure that the file that's being referenced in the vlookup formula is already opened. It will make your macro run quicker. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Integrate a Vlookup function in to a macro
It is c.formula "=VLOOKUP(A6,'[Commissions Master
Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE)" or cells(i,j).formula = "=VLOOKUP(A6,'[Commissions Master Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE)" Regards Peter " wrote: On Apr 12, 6:16 pm, Arain wrote: I have no clue how to add this vlookup function to a macro. The formula is =VLOOKUP(A6,'[Commissions Master Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE) Its working great if I keep copy pasting the formula but I want to take it a step ahead and automate it. Part of the recording of your macro should be typing vlookup formula. It will work.. I've done it many time myself. When you run your macro, make sure that the file that's being referenced in the vlookup formula is already opened. It will make your macro run quicker. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Specifying cell(s) for Vlookup Function in Macro | Excel Discussion (Misc queries) | |||
| Getting a cell address from Vlookup function in a macro? | New Users to Excel | |||
| How Do I Integrate? | Excel Discussion (Misc queries) | |||
| integrate | Charts and Charting in Excel | |||
| Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
Linear Mode
