| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select different workbook in vba?
i would like this code to point to workbook "test1" instead of ActiveWorkbook.
does this code need rewriten? everything i have tried has not worked. i am very much a novice at vba. this code works well if the information remains in the ActiveWorkbook, but for security it needs to be moved. Private Sub OldPriceLookup() With ActiveSheet If .Range("B17").Value = "n/a" Then ' clear out the old price .Range(sOldPriceCol).Value = "" ElseIf .Range("B17").Value = "A02" Then ' A02 = 29 ' set the old price (only need to change the column Number "29") .Range(sOldPriceCol).Value = WorksheetFunction.VLookup(Range("B19").Value, ActiveWorkbook.Sheets("casing").Range("1:65536"), 29, False) ElseIf .Range("B17").Value = "A03" Then ' A03 = 30 ' set the old price (only need to change the column Number "30") .Range(sOldPriceCol).Value = WorksheetFunction.VLookup(Range("B19").Value, ActiveWorkbook.Sheets("casing").Range("1:65536"), 30, False) it does have an end, just not shown. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| workbook select | Excel Discussion (Misc queries) | |||
| select workbook | Excel Programming | |||
| Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Threaded Mode
