Toppers your a gem
works perfectly

Thanks for the help

"BrianW" wrote:

Hi Toppers
Thanks for that. Here is my currant macro
Range(ActiveCell, ActiveCell.Offset(0, 10)).Select

With Selection.Interior
.ColorIndex = 37
.Pattern = xlSolid
End With
Selection.Font.ColorIndex = 3
Selection.Font.Bold = True

I'll add your code and see how I go.
Cheers
Brian


"Toppers" wrote:

Brian,
Assuming the active cell is (somewhere) in the row requiring
formatting then you could use:

Range("C" & ActiveCell.Row & ":G" & ActiveCell.Row).NumberFormat =
"dd/mm/yyyy" ' <==== set as a date format

Avoid selecting if possible as it is inefficient.

HTH

"BrianW" wrote:

Hi there
I want to create a macro that will select column C as my active cell
regardless of where my cursor is in that row.
For example, the cell I may have selected is say BB300 or G300 or Z300. When
I run my macro I want to select column "C" as my active cell so that I can
then select cells C300-G300 for custom formatting.
TIA