RE: Excel VBA - How do I make the third column in a row the active
Thanks for that. Here is my currant macro
Range(ActiveCell, ActiveCell.Offset(0, 10)).Select
.ColorIndex = 37
.Pattern = xlSolid
Selection.Font.ColorIndex = 3
Selection.Font.Bold = True
I'll add your code and see how I go.
> 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.
> > TIA
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1