convert to range

  1. Pinaceous

    VBA Convert to Range

    Hi All, Is there a way through VBA that I can change one of my tables by macro to 'Convert to Range'? Thanks, Pin
  2. R

    Convert Table to normal range, table name unknown

    Folks: How do I use this formula in excel vba...: ActiveSheet.ListObjects("Table_Dyna_1").Unlist ...If I don't know the name of the table, or the table name will change? Like maybe today the table name is "Table_Dyna_1" but later it could be "Table_Dyna_1_1" or "Table_Dyna_2" (probably...
  3. G

    VBA to convert table to range

    Dear All, I am looking for VBA to convert a table to a range. I used the macro recorder and selected the Convert to range option from the Table Ribbon. The resulting macro was completely empty: Sub Macro2() ' ' Macro2 Macro ' ' End Sub Any ideas? Thanks, GL

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top