Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data table function
how do i call the data table function in VBA?
Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data table function
Try this:
Sub Test() Set dataTableRange = Worksheets("Sheet1").Range("A1:K11") Set rowInputCell = Worksheets("Sheet1").Range("A12") Set columnInputCell = Worksheets("Sheet1").Range("A13") Worksheets("Sheet1").Range("A1").Formula = "=A12*A13" For i = 2 To 11 Worksheets("Sheet1").Cells(i, 1) = i - 1 Worksheets("Sheet1").Cells(1, i) = i - 1 Next i dataTableRange.Table rowInputCell, columnInputCell With Worksheets("Sheet1").Range("A1").CurrentRegion .Rows(1).Font.Bold = True .Columns(1).Font.Bold = True .Columns.AutoFit End With End Sub -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "dstiefe" wrote: how do i call the data table function in VBA? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data table function | Excel Worksheet Functions | |||
Limit to Data/Table function | Excel Discussion (Misc queries) | |||
how do i automate an index function with a data table | Excel Worksheet Functions | |||
Can a pivot table function like data filter? | Excel Programming | |||
Can a pivot table function like data filter? | Excel Programming |