| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Creating Tables in Excel 2007
Hi to all, I am downlading a File form external data and want to turn this
automaticlly in to table in excel 2007, when I run the macro this takes only the selected range, but my download is never the same Size. Take a look at what i have and please help correct it Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$J$57"), , xlYes).Name = _ "Table1" Range("A1:J57").Select ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleMedium18" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Re-creating tables in Access from Excel | Excel Programming | |||
| Creating tables using AutoFilter in Macro | Excel Programming | |||
| Creating Pivot Tables with macro Problem | Excel Programming | |||
| Creating Pivot Tables inside a Macro | Excel Programming | |||
Threaded Mode
