View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Scott Spence Scott Spence is offline
external usenet poster
 
Posts: 16
Default Create Table with the range of selected cells

Like this:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _
Format(Now(),"yyy/mm/dd")