Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range - select row
In my macro I have a range set to a single cell. The cell the range refers
to changes throughout my program. I want to bold the entire row (or at least the first X columns in that row) that the range is on. Thanks, Scott Hanebutt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range - select row
dim myCell as range
set mycell = worksheets("sheet99").range("x99") 'or something mycell.entirerow.font.bold = true or mycell.entirerow.resize(1, 10).font.bold = true Change 10 to whatever X meant. scott_hanebutt wrote: In my macro I have a range set to a single cell. The cell the range refers to changes throughout my program. I want to bold the entire row (or at least the first X columns in that row) that the range is on. Thanks, Scott Hanebutt -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range - select row
Hi Scott,
try: SingleCell.EntireRow.Select Frederick Chow "scott_hanebutt" wrote in message ... In my macro I have a range set to a single cell. The cell the range refers to changes throughout my program. I want to bold the entire row (or at least the first X columns in that row) that the range is on. Thanks, Scott Hanebutt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range - select row
This is just an example. Select a single cell and run this macro:
Sub Macro3() Dim r As Range Dim s As String Set r = Selection s = r.Row Rows(s).Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With End Sub Of course, you would set r to whatever your range is, not Selection. -- Gary's Student "scott_hanebutt" wrote: In my macro I have a range set to a single cell. The cell the range refers to changes throughout my program. I want to bold the entire row (or at least the first X columns in that row) that the range is on. Thanks, Scott Hanebutt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range - select row
Thanks to everyone who replied. I decided to use Dave's suggestion and it
worked perfectly. Thanks, Scott Hanebutt "scott_hanebutt" wrote: In my macro I have a range set to a single cell. The cell the range refers to changes throughout my program. I want to bold the entire row (or at least the first X columns in that row) that the range is on. Thanks, Scott Hanebutt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
How do I select a range using VBA? | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |