Create Table with the range of selected cells

[antik888]

Hi guys!

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

Thanks for any help.
Anton

 

[Gord Dibben]

Have you tried the macro recorder?

If you run into any issues, post back with the code and expected
results.


Gord

 

[Scott Spence]

Return the range of selected cells:

Selection.Address

 

[Scott Spence]

Return the range of selected cells:

Selection.Address

Will return a string with the selected area address

 

[antik888]

Hi guys!

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

Thanks for any help.
Anton.

The code looks like this


Code

 

[Scott Spence]

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

 

[Scott Spence]

Like this:

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

 

[Scott Spence]

Like this:

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