Advanced Search

Return to Snippet

Revision: 4957
at January 31, 2008 04:18 by neozhang
Initial Code 
Dim t as Long

If Application.IsNA(Application.VLookup(item, rng1, 10, 0)) Then
    t = 0
Else
    t = ActiveCell.Offset(0, 51).Value
End If

# use t instead of the cell value in the following calculation
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Avoid #N/A to Cause "Type Mismatch"

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
excel

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Visual Basic