View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bao Guangya Bao Guangya is offline
external usenet poster
 
Posts: 1
Default why I got error value after running this code?

dim cnum1,cnum0

cnum1 = 6
cnum0 = 3
cells(2,3).formula = "=vlookup(A2,sheet1!C:F,cnum1 - cnum0 + 1,0)"