Selecting part of column

[Rob K]

Hi there,

I have a macro that a kind gentleman did for me that highlights the weekend in a spreadsheet of a weekly time sheet, I am trying to neaten it up a little. I have this line:

Please Login or Register  to view this content.

But what I really want is to select only 20 cells of this column from fourth row down to row 24, what would be a syntax that could replace the line I have there. In the past I have just used Range, but I can't see how to tie it up to the columns that I am selecting.

Can anyone help me with this please.

Kind regards
Rob

[StephenR]

Rob - you could use this, but note you rarely need to Select in VBA, and generally not advisable

Please Login or Register  to view this content.

[Rob K]

Thank you, could you elaborate on the not selecting advice, or point me at a page that explains this, I would rather write code that is robust.

[Rob K]

Hmm, no, I can't get this to work, here is what I am trying to put it into:

Please Login or Register  to view this content.

I really don't think this should be that difficult to do, I just want to format the weekends in a different colour for a list of 20 people, but 3 days later and I still can't find a way.

[StephenR]

Not sure you even need VBA, conditional formatting might do the job, but try this:

Please Login or Register  to view this content.

[Rob K]

Conditional formatting was actually what I wanted, but I could not find a way to do it that worked.

I'm doing something seriously wrong, I can't get either this or my previous macro to run now. For some reason it is skipping over the conditional statement. Basically on row 4, I have dates from now to april next year, then row 5 are the weekdays. The thing is, I don't know what :

Please Login or Register  to view this content.

means. How can I find out what value this is referring to? is it a date, or is it the number of the day in this year? or the day in the week?

I really thought this would be a really simple thing to do.

[StephenR]

I suggest you post a workbook. Btw your code is only run when the sheet is activated. You can consult Help - press F1 - for definitions etc.