_QueryTable.TablesOnlyFromHTML _QueryTable.TablesOnlyFromHTML _QueryTable.TablesOnlyFromHTML Property

Definition

Creates a data table based on input values and formulas that you define on a worksheet.

public:
 property bool TablesOnlyFromHTML { bool get(); void set(bool value); };
public bool TablesOnlyFromHTML { get; set; }
Public Property TablesOnlyFromHTML As Boolean
Property Value

Examples

<p>This example creates a formatted multiplication table in cells A1:K11 on Sheet1.</p>
<pre><code>&lt;span class="label"&gt;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.</span> <i>Table</i> <span class="label">rowInputCell, columnInputCell With Worksheets("Sheet1").Range("A1").CurrentRegion .Rows(1).Font.Bold = True .Columns(1).Font.Bold = True .Columns.AutoFit End With</span>

<p>This example creates a formatted multiplication table in cells A1:K11 on Sheet1.</p>
<pre><code>&lt;span class="label"&gt;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.</span> <i>Table</i> <span class="label">rowInputCell, columnInputCell With Worksheets("Sheet1").Range("A1").CurrentRegion .Rows(1).Font.Bold = True .Columns(1).Font.Bold = True .Columns.AutoFit End With</span>

<p>This example creates a formatted multiplication table in cells A1:K11 on Sheet1.</p>
<pre><code>&lt;span class="label"&gt;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.</span> <i>Table</i> <span class="label">rowInputCell, columnInputCell With Worksheets("Sheet1").Range("A1").CurrentRegion .Rows(1).Font.Bold = True .Columns(1).Font.Bold = True .Columns.AutoFit End With</span>

Remarks

Use data tables to perform a what-if analysis by changing certain constant values on your worksheet to see how values in other cells are affected.

Applies to