LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Bold contents of a variable

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add only cells whose contents are in "Bold" oisinirish Excel Discussion (Misc queries) 3 February 22nd 09 07:30 PM
change cell contents to bold dave@penneys Excel Worksheet Functions 5 September 20th 07 08:25 PM
clear cells unless contents are in bold John Jones Excel Programming 1 August 24th 05 01:07 PM
Bold some of the cell contents Brad Excel Programming 4 April 25th 05 04:49 PM
Dump of all variable contents Bernie Deitrick Excel Programming 0 February 20th 04 04:18 PM


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"