Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - How do I make the third column in a row the active
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last cell in a column, Delete its contents and make it active | Excel Worksheet Functions | |||
VBA: Make Excel the active application | Excel Discussion (Misc queries) | |||
Can I make a Excel Active Desktop Worksheet on XP? | Excel Discussion (Misc queries) | |||
How do I make email addresses in a column of cells active links? | Excel Discussion (Misc queries) | |||
Make excel the active page | Excel Programming |