View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Purnima Sharma Purnima Sharma is offline
external usenet poster
 
Posts: 1
Default selectin all the values in a column including null values

Hi,
I want to write Vb code in a macro which would change all the values in a
column to a certain value. It should include all the null values as well. Is
there any command like end of file in VBA. The code I have written works
fine until it hits a space(null value) and doesn't change the value
afterwards probably because it considers that as en end of file. How can I
include all the values in a column. Can someone help.
Thanks.
Purnima sharma