VBA: Multiply Cells by Value but Skip Blanks

[jblack6572]

Excel Sheet attached.

What I want to do is multiply each number in a range by a defined value. The problem I have is I also want:

-To do nothing to blank cells
-To start multiplying at a certain point in the range which changes daily (in my spreadsheet, I want to start with the first cell that corresponds to "Not Yet Played")

Here's what I have got so far:

Please Login or Register  to view this content.

[BillyRaySpivy]

Good thing you provided a sample maybe you will get some help. Good luck.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[jblack6572]

This is almost perfect, but when it performs the multiplication (.Value*y), it uses the value in the first cell of the range, for the entire range. As in, its not taking the values as they come, only the very first one, so all the numbers end up the same. Its like .Value is somehow a constant?

Any ideas.

[JOHN H. DAVIS]

Yes. Need to do a for each loop with Range("wager").SpecialCells(2, 1). I have to run right now. If no one else helps or you need help, I can continue tomorrow morning.