Hi,

First post here (glad I found this place!).

I'm converting an extremely important Quattro Pro spreadsheet to Excel after 20+ years!

Running into a lot of things that may seem quite simple to some of you - but the syntax and expressions are different from Quattro to Excel and I'm struggling.

I have macros that I need to rebuild in Excel (for Mac 2011, vers. 14.4).

This is the first one I can't figure out. I'll express it in simple English first:

a) Within a DO loop, check incremented cell value for a substring.

b) If substring not found, change cell values to blank (blank incremented cells A, B).


Loop needs to check a range of cells (D24:D308).

Here's a simplified expression (syntax is very incorrect):

If (Ordering!D24<>"My Value",Ordering!A24:b24="", otherwise do nothing).

I have figured out how to use the Range statement to change a cell value, but not with an incremented cell pointer.

I don't know how to use the Dim and Integer variables correctly within the IF statement.

I got this far:

Dim i as Integer
i = 24
Do Until i > 308

missing IF statement goes here

i = i + 1
Loop


Probably not much of a challenge, but my IF syntax attempts crash the compiler.


Any help at all is much appreciated!