I have a simple table on worksheet "Table" in Excel. Let's say the table is called "SortTable" and has 8 rows by 4 columns. I want to populate a vba array with the contents of the table. I have seen 3 or 4 ways of doing this. None work for me - I get the error message "Can't assign to array"...
'declare variables
Dim combo As String 'Combo worksheet name
Dim SortTable As String 'Table name that needs sorting
'assign values to variables
combo =...
Hi Everyone!
Col G and H has data sort of table.
I want to know if there is anyway to sort the table accoring to range name in table suppose range(G12:H17) named = name1, range(G18:H21)
= name2 etc...
When i select the validation from the table to be sort by name range....I've seen Bill did...
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.