Thread: Another avoid the loop trick request - on fast fill (Maybe an Alan trick)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default Another avoid the loop trick request - on fast fill (Maybe anAlan trick)
wrote:

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 way 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....

I agree with Myrna Larson's reply. The following has the functionality
the OP requested, but I have no idea whether it meets the requirement
that it be a "fast way".

Alan Beban
Reply With QuoteReply With Quote