Thread: Ignore Blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
todd todd is offline
external usenet poster
 
Posts: 48
Default Ignore Blanks

Hi All,

I am currently writing a macro that pulls data in from a
text file, my problem is that the text file contains
blanks and i won't to write a macro that will ignore all
the blanks, and when it reaches a character to read it
into the spreadsheet
Can anyone suggest how i can ignore these blanks?
Thanks