Programmers,
My imported dataset has null values.
Currently I loop through the columns and rows; and use this is code:
IF .CELL(lRow, lCol).Value = "" THEN .CELL(lRow,lCol).Clear
This method takes a long time.
Could the .Range &/or Evalute method be used?
Something like:
With...