copy dimensons

[speary]

is there a way to copy just the dimensons of a range, say (a1:a10) an
not the values that range contains to another range, say(c1:c10) in vb

 

[Dave O]

Do you mean you'd like to copy the format of a1:a10 to c1:c10, without
copying values? Or is a1:a10 a named range?

 

[speary]

i think i just need the formats, i.e. if their are 10 data files in
column a then there will be 10 in column c and so forth. i need all the
columns (a,c,d) to contain the same number of files as column b. but in
my spreadsheets the number of files in the column will change i.e.


sheet 1 col a 2330 files
sheet 2 col a 1870 files
sheet 3 col a 1500 files


also these numbers will change in the future.