View Single Post
  #5   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

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