Clearing the status cells

[nigelk]

I've just been looking at a Golf market, and the players went all the way down to row 295.

I know the accepted method is :

Range( _
"O6,O9,O11,O13,O15 etc,etc,etc

but that's still a hell of a lot of typing to do.

Maybe:


Range("O9:O300") = ""



would be easier?

[andydoc]

There is a limit to the number of arguments a range definition can take. I have overcome this by the following: Range("Destination").formula = Range("Source").formula, and having the "Source" Range copied in to the Destination each time an event goes In-play (as that is how I trade, although you could do it each time it is suspended, or each time countdown gets to e.g. 5s). You have to be careful to have the formulae in "Source" to read as they should and not changed by the offset of rows/columns from Destination to Source

[TheTub]

Good point.

My macro just uses the 'Range("O9,O11,O13,O15....' and so on method all the way to O67. And I've found this is OK for all the events I get involved in.

Range("O9:O300") will also select the instruction cells so is no good.

What about a loop?

[nigelk]

Seems to work ok for me?

Cells O10, O12, O14 etc, don't exist (so no need to step through), as the cells below are merged and what should be O10 is now classed as L10

However, I am getting worried, as on my sheet L10, L12 etc are formatted as text, but someone else told me that theirs wasn't.

I may have changed some of my basic settings somewhere and forgot about it, if so, someone please point me in the right direction!

[TheTub]

You're right.

I was using Range("O9:O300").Activate then Selection.ClearContents

On my sheet the cells L10, L12 and so on are formatted as text with the instruction cells (L9, L11...) formatted as general.

[nigelk]

Thanks Tub.

Nigel.