color the last used row in a range

[excelhelpseeker]

Hi Champs,

I need to select the last of a range say

A17:J17 and colour the cells. (pls note that last row address may vary)

Please help me with a macro.

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

Or?

Please Login or Register  to view this content.

[Arkadi]

Hi,

Try this? replace the term sheet_name_here with the real name of your worksheet.

Please Login or Register  to view this content.

[excelhelpseeker]

thanks. works fine

[alansidman]

try this:

Please Login or Register  to view this content.

[excelhelpseeker]

hi champs,

same way is that possible to make all the cells font color to RED in A:C

in A:C column, all the cells to be in font red but not the last two rows....


eg if A60:C:60 means, the rows 59 and 60 should not be in red.

[Arkadi]

Something like this?

Please Login or Register  to view this content.

'replace "Sheet1" with real name.

[excelhelpseeker]

thanks arkadi an, alansidman and john. you rock.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.