I need help with macro that when i run, it selects the current region and then converts it to table.
i used macro recorder which gave me the following code. but as you can see that the range Range("$A$1:$AM$13") is hardcorded and it is not dynamic next time, if i want to use this macro, it will only create table from range Range("$A$1:$AM$13"), which is incorrect, becuase my data range varies.
any help appreciated.
' Macro1 Macro
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$AM$13"), , xlYes).Name = _