View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Perry Chris Perry is offline
external usenet poster
 
Posts: 2
Default define end column in a range

I would like to accomplish two things in vb code:
1) create a variable that defines the last column of a
given range (i.e. lastcol = ?).
2) Then use the variable as part of a selected range (i.e.
Range("A1:lastcol")