| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deaking with nulls, I think...
the below code is bombing if it finds a null in a field of my lookup table;
how can I prevent this? Private Sub cbVenCode_AfterUpdate() Set MyVenTable = Range("VenTable") txtVenName.Value = Application.VLookup(Me.cbVencode, MyVenTable, 2, False) txtVAdd1.Value = Application.VLookup(Me.cbVencode, MyVenTable, 3, False) txtVAdd2.Value = Appliction.VLookup(Me.cbVencode, MyVenTable, 4, False) txtCity.Value = Application.VLookup(Me.cbVencode, MyVenTable, 5, False) txtSt.Value = Application.VLookup(Me.cbVencode, MyVenTable, 6, False) txtZip.Value = Application.VLookup(Me.cbVencode, MyVenTable, 7, False) End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I test for nulls within a range without specifying each ce | Excel Discussion (Misc queries) | |||
| Handling nulls found in expression | Excel Discussion (Misc queries) | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| average cells omitting nulls | Excel Worksheet Functions | |||
Threaded Mode
