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


--
speary
------------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
View this thread: http://www.excelforum.com/showthread...hreadid=385229

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?

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.


--
speary
------------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
View this thread: http://www.excelforum.com/showthread...hreadid=385229