Use VBA for IF instead of Excel?

[Rick-O-Shay]

Hi,

Is it possible to use VBA for an IF function? I have a file and in column A I have this formula =IF(N2>"","Test"). So basically, if there is nothing in N2, there is nothing in column A, otherwise put in the word "Test".

My problems is that that formula is copied down 10,000 times so if I need to print or upload this file to 3rd party software, even though it's blank, it tries to read/print that formula.

I would like to make a simple script in VBA and tie it to a command button so that if N2 is blank A2 is Blank all the way to N10001 otherwise Test so that there really is no data in those cells and it doesn't mess up printing or file uploads.

Is this possible?

Thanks,

[Rick Rothstein]

Assuming the values in Column N are constants (that is, not formulas), does this macro do what you want...

Please Login or Register  to view this content.

[Rick-O-Shay]

Hmm, I just get error 400

[Rick-O-Shay]

Attaching a sample workbook.

It just throws an errors with 400.

[Rick Rothstein]

Argh! I made a last minute change and screwed it up! Try this instead...

Please Login or Register  to view this content.

[Rick-O-Shay]

That is exactly what I needed! Thanks!!