Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Both of Chip's worked for me whether Cell.Offset(1,0) was empty or not when
I corrected your code to use the correct variable name. Maybe a little more thorough testing on your part would be beneficial. -- Regards, Tom Ogilvy "mikeburg" wrote in message ... Thanks a million for your responses. I was only wanting to bold the member number part of the cell. Your replies were working but the BusinessNumber was not bolding when the BusinessName was sometimes blank (no business name existed), but the last reply worked great! Thanks so much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=514176 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add only cells whose contents are in "Bold" | Excel Discussion (Misc queries) | |||
change cell contents to bold | Excel Worksheet Functions | |||
clear cells unless contents are in bold | Excel Programming | |||
Bold some of the cell contents | Excel Programming | |||
Dump of all variable contents | Excel Programming |