Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the code at http://www.vbaexpress.com/kb/archive.php/k-743.html
to change the color of some text in an Excel 2003 spreadsheet. Here is how I am generating the range object specifier: ActiveCell.Offset(0, 1) = "TopLine" & vbLf & "BottomLine" ActiveCell.Offset(0, 1).Font.Color = vbBlack 'Call xlCellTextMgmt(Range("K20"), "TopLine", , , , , 3) Call xlCellTextMgmt(ActiveCell(0, 1), "TopLine", , , , , 3) When I submit Range("K20") to xlCellTextMgmt, nothing happens. When I submit ActiveCell(0, 1) instead, all is fine. I know that they refer to the same cell because the first two lines populate that cell. Thanks for any debugging suggestions....Been banging at it for a while. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RANDBETWEEN generating numbers outside range | Excel Worksheet Functions | |||
Automatically generating a number range | Excel Worksheet Functions | |||
different ways to copy a range? | Excel Programming | |||
Alternative Ways to Spellcheck a Range | Excel Programming | |||
Example: Generating a Range String from numbers. | Excel Programming |