i = 1 to 15

[Sc0tt1e]

I have tried this with the For i = 1 to 15 but it asks for a next which isn't relevant to what I am doing.

How do I set "i" with a variable value?

Example of what I am doing

Please Login or Register  to view this content.

CellRef value increases to 13 as a duplicate of this code

[Ron Coderre]

Every FOR requires a corresponding NEXT.
The NEXT statement causes the code to increment your variable.

Does that help?

[PCI]

A suggestion for your code
Care about the FOR and the IF statement

Please Login or Register  to view this content.

[Sc0tt1e]

That was just a sample of the code. See below for the full code, you will see there is no need for a next in the code I just want to have one line of code for CellRef rather than 13 lines so my question still stands

How do I assign "i" with the values 1-13 without using "For/Next"

Please Login or Register  to view this content.

[Ron Coderre]

If you want to sequentially increment a variable there's no getting around using one of VBA's looping constructs:
For/Next
Do/While
Do/Until
For Each/Next

Choose one and implement it.

[Sc0tt1e]

I don't want to increment it I just want to say "If anything between CellRef 1-13 is greater than "" then MsgBox"", not loop through 1-13 and check all

[Ron Coderre]

If CellRefs 1-13 are a contiguous in a row or column, then you could use one of Excel's native functions within VBA.
Something like:

Please Login or Register  to view this content.

Otherwise, you'd need to either test each individually or using one of the looping constructs.