Statements

[sburkhar]

How do you write and "If" statement for an array of cells?

 

[hatman]

It all depends on what you are trying to do... Can you supply some additional information?

 

[sburkhar]

I need the statement to appear in 3 columns for 500 lines each. Do I have to copy and paste the statement into EVERY cell individually or is there another way to do it?

 

[hatman]

Enter the formula in the upper right-hand cell. Copy it. Then select 3x500 cells, and paste.

or

Enter the formula in the upper right-hand cell. Select the cell. Grab th elower right-hand corner of the cell (you will see a little grip, and when you hover the cursor changes to a black cross) and drag to the right as many columns you need. Release the grip. Then grab the grip again, and drag down as many rows as you need, and release.

 

[sburkhar]

This is VBA coding. I don't think you can drag and drop like that.

 

[Norie]

sburkhar

I think we need some further information.

 

[hatman]

Oh... that's the first time you mentioned that. Could you please post the portion of your code that is relevant here?