View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default Another avoid the loop trick request - on fast fill (Maybe an Alan trick)

Since there was such a wonderfully useful way to round all the items in
a range as they are loaded into an array posted -

I'm wondering if there is a fast was to fill an entire column of values
in an array with a particular value?

In otherwords .....

2 x 2 array....

C1 C2 C3
R1 v1
R2 v1
R3 v1
.. v1
.. .
.. .

Where R is row, C is column and V is the value....