Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Column Range
Hi all, When i put a value into a cell in Column D. Put bottom border in cells on that row, but just Columns A:F This works except for the way i am selecting Col A:F If i just put A or F it works for that one column. Any direction? Code: -------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 Then With Range("A:F" & Target.Row) With .Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With End With End If End Sub -------------------- -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=492462 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Column Range
Hello Desert Piranha, With Range("A" & Target.Row, "F" & Target.Row) Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=49246 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Column Range
Hi Leith, Thats wonderfull. Works great. Thanks much. Dave Leith Ross Wrote: Hello Desert Piranha, With Range("A" & Target.Row, "F" & Target.Row) Sincerely, Leith Ross -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=492462 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I lost the highlight color when selecting a range, column or row. | Excel Discussion (Misc queries) | |||
Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting specific row/column from a named range | Excel Worksheet Functions | |||
Selecting a range using a column number reference | Excel Programming |