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.


"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.