| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Create Table with the range of selected cells
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. |
|
#2
|
|||
|
|||
|
Quote:
The code looks like this Code:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _
"Table3"
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
Like this:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _ Format(Now(),"yyy/mm/dd") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
Like this:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _ Format(Now(),"yyy/mm/dd") |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:A2"), , xlYes).Name = _
Format(Now(),"yyyy/mm/dd") |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
Have you tried the macro recorder?
If you run into any issues, post back with the code and expected results. Gord On Sun, 29 Jan 2012 18:55:29 +0000, antik888 wrote: 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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
Return the range of selected cells:
Selection.Address |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Table with the range of selected cells
Return the range of selected cells:
Selection.Address Will return a string with the selected area address |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create table of selected rows | Excel Worksheet Functions | |||
| Create interactive pivot table chart based on item selected | Charts and Charting in Excel | |||
| create a thin border around the selected cells | New Users to Excel | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| how do i create a formula for selected range? | Excel Worksheet Functions | |||
Hybrid Mode
