Hi Team,
I am using an excel having lots of formulas which was working fine on 2003 but now we have migrated to 2010 and here facing problems:
#1.I am getting type mismatch error 13 in below code
For I = 17 To 26 Step 1
Range("G" & Format(I, "0")).Select
J = Range("G" & Format(I, "0"))------------- Range("G" & Format(I, "0")) returns #N/A value
If (J = 0) Then
Selection.EntireRow.Hidden = True
End If
Next I
.
#2.Formula "=VLOOKUP("Yes",Elig!$G$10:$H$259,Elig!$H$6-Elig!$G$6+1,FALSE)" is not working, on using evaluate it reduces to =VLOOKUP("Yes",Elig!$G$10:$H$259,2,FALSE) and finally result to #N/A. Here worksheet have multiple tabs and range given in one tab which is referring data insecond tab is not working.
Please suggest.
Bookmarks