| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code works on sheet but not from code-to-sheet
On Tuesday, June 4, 2013 7:29:10 PM UTC-7, Ben McClave wrote:
Howard, Try this: Sub X() With Range("A1:A5") .Formula = "=IF(VLOOKUP(C1,$D$1:$F$5,3,0)=0,"""", VLOOKUP(C1,$D$1:$F$5,3,0)))" .Value = .Value End With End Sub Thanks, Ben. Works smack on, just had to add the missing "(". .Formula = "=IF(VLOOKUP(C1,$D$1:$F$5,3,0)=0,"""",(VLOOKUP(C1, $D$1:$F$5,3,0)))" Regards, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display one sheet or two userforms while code is vba code is runningon another | Excel Programming | |||
| Code to change code in a sheet and workbook module | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Code Only works when sheet is in focus | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Threaded Mode
