var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: create array from range of cells
My code currently has this line:
Sheets(Array("BA", "CA", "Co", "To", "Ex", "GW","AL")).Select
if the name of a sheet changes it breaks my code.
I dont want to select all the sheets, so i added a method that writes only the current name of sheets i want to select to a range on a spread sheet, so
how do i read those values to an array given that i selected the range of values already (range("TheNames").select ) ?
i don't fully understand your problem. see if this solves it...
if you want to use the data in cells as array (i.e) data in the cell "A1",
the code line is...
now, since you have already selected the range, try using
(range("TheNames").value) instead of (range("TheNames").select).
Everyone is gifted! Some open the package sooner!