View Single Post
  #2   Report Post  
antik888 antik888 is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by antik888 View Post
Hi guys!

I need some help with setting up vba that would insert a table with headers, with the name of current time and most importantly range of the selected cells.

Thanks for any help.
Anton.

The code looks like this

Code:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _
        "Table3"
But I need to change the name of the table to current date or time. How would it look like?