View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EKUFan EKUFan is offline
external usenet poster
 
Posts: 1
Default How do I use a Macro to define a Named Range

I have a spread sheet in which I have to continually update a named range.
The number of columns is static and the number of rows grow with new
information every day. The named range includes columns A thourgh CX. There
my not always be an entry in Column A. The first Column where there will
always be information is column B. How do I use a macro to do this.