Macro If Then Question

[mslabbe]

Hi All! I love this discussion group! I usually find what I'm looking for,
but not this time.

I would like to run a macro based on a column. Example, if A7:A500>0, then
copy F7:F500. Basically, if A7 is >0, I would like F7 to be copied and paste
in BB7, and for it to go down to 500.

Thanks in advance
Cheers

 

[Steve Schapel]

Mslabbe,

The focus of this group is macros in Access, the database program. Your
question appears to be related to a spreadsheet. You may have a better
chance of a good answer if you re-post to a more applicable newsgroup,
such as one that is related to Excel.

 

[mslabbe]

Yes...I guess I was a bit too excited and asked in the incorrect
group...sorry for this.

Cheers