named table

  1. R

    Userform to fill first empty row in named table

    Hi, I have a userform with text fields and checkboxes. The data entered in the userform will be transfered to a new row in the named table "tblColleagues". This table already contains a few rows with data but the named table range also covers lots of empty rows. How is it possible to make the...
  2. C

    How to target Worksheet_change() on only a specific named column of a table in the sheet

    Hi Hope to have some advice on this problem. In worksheet "Work" I have a table named "tbl_work" which contains named columns "colA", "colB", "colC".... I want something to happen only when changes occur in "colB". Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents =...
  3. I

    Create an array from selected rows from Named Table

    Hello everyone! Can't solve a problem.. There is a named table on sheet. User selecting one or several rows and starting a macro. The point is to make 2-D array with columns and rows, selected by user. I use a "union(r1, r2..)" statement to make consolidated range that I want to insert in...
  4. A

    VBA to replace named table, without changing table name

    Hi, I'm trying to use vba to update a table in my spreadsheet. Each time I run the macro it copies a table form workbook 1, called "Table1", into the same position in my new workbook. I then have some formulas in the second workbook that calculate things from the table. These formulas refer to...
  5. S

    Vlookup ghost named table

    Hi, Check this out, pls I created an Excel file in my PC and another one in a USB Key. Just a dummy files.</SPAN> I created a named table in the file in the Key</SPAN> I created a VLOOKUP in the file in my PC pointing to the named table in the USB</SPAN> I saved the PC file</SPAN> I removed...

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