I currently have my macro populating cells on my spreadsheet and letting the spreadsheet perform the calculations. The sheets are getting very large and the calcs are slowing it down. So instead, I'd like to have the code perform the calcs and put the values in the cells.
The current equation:
=IF(ISNUMBER(MATCH(B2,'EMP List'!A:A,0)),IF(VLOOKUP(B2,'EMP List'!A:G,7,0)="","n/a",VLOOKUP(B2,'EMP List'!A:K,11,0)),"")
With code:
Range("H2").Value = "=IF(ISNUMBER(MATCH(B2,'EMP List'!A:A,0)),IF(VLOOKUP(B2,'EMP List'!A:G,7,0)=" & Chr(34) & _
Chr(34) & "," & Chr(34) & "n/a" & Chr(34) & ",VLOOKUP(B2,'EMP List'!A:K,11,0))," & Chr(34) & Chr(34) & ")"
How do I translate this into a VBA only claculation and input the value in cell H2?
Thanks!
The current equation:
=IF(ISNUMBER(MATCH(B2,'EMP List'!A:A,0)),IF(VLOOKUP(B2,'EMP List'!A:G,7,0)="","n/a",VLOOKUP(B2,'EMP List'!A:K,11,0)),"")
With code:
Range("H2").Value = "=IF(ISNUMBER(MATCH(B2,'EMP List'!A:A,0)),IF(VLOOKUP(B2,'EMP List'!A:G,7,0)=" & Chr(34) & _
Chr(34) & "," & Chr(34) & "n/a" & Chr(34) & ",VLOOKUP(B2,'EMP List'!A:K,11,0))," & Chr(34) & Chr(34) & ")"
How do I translate this into a VBA only claculation and input the value in cell H2?
Thanks!