| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in VBA
I'm trying without success to place the following formula into cell C1 via
VBA code, the formula works fine within the spreadsheet: =VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)&" "&A1&" W/E: "&TEXT(B1,"dd-mmm-yyy") So far i've got this part to work but the A1 and B1 elements just don't want to know! Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),"myfile!Database,2,FALSE) " Any help will be most welcome. Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup in VBA
Hi Rob,
Maybe a typo? -- Kind Regards, Niek Otten Microsoft MVP - Excel Leave out the quote before myfile "Rob" wrote in message ... I'm trying without success to place the following formula into cell C1 via VBA code, the formula works fine within the spreadsheet: =VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)&" "&A1&" W/E: "&TEXT(B1,"dd-mmm-yyy") So far i've got this part to work but the A1 and B1 elements just don't want to know! Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),"myfile!Database,2,FALSE) " Any help will be most welcome. Rob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup in VBA
Rob,
Is this what you want Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)& A1&"" W/E: ""&Text(B1, ""dd-mmm-yyy"")" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Rob" wrote in message ... I'm trying without success to place the following formula into cell C1 via VBA code, the formula works fine within the spreadsheet: =VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)&" "&A1&" W/E: "&TEXT(B1,"dd-mmm-yyy") So far i've got this part to work but the A1 and B1 elements just don't want to know! Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),"myfile!Database,2,FALSE) " Any help will be most welcome. Rob |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup in VBA
Bob,
Thanks once again, it was the double quotes"". Regards, Rob "Bob Phillips" wrote in message ... Rob, Is this what you want Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)& A1&"" W/E: ""&Text(B1, ""dd-mmm-yyy"")" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Rob" wrote in message ... I'm trying without success to place the following formula into cell C1 via VBA code, the formula works fine within the spreadsheet: =VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)&" "&A1&" W/E: "&TEXT(B1,"dd-mmm-yyy") So far i've got this part to work but the A1 and B1 elements just don't want to know! Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),"myfile!Database,2,FALSE) " Any help will be most welcome. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
