View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ROSE THE RED ROSE THE RED is offline
external usenet poster
 
Posts: 1
Default SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,

I HAVE A WOORKSHEET THAT HAS WHOLE ROWS WITH SPACES IN BETWEEN SOME ROWS WITH
DATA. ON ANOTHER WOORSHEET I WANT TO JUST HAVE THOSE ROWS THAT CONTAIN DATA.
THE ORIGINAL CANNOT CHANGE. THANKS.