A better bit of code is

Cell.Offset(1, 1).Characters(Len(BusinessName) + 1, _
Len(Str(MemberNumber))).Font.Bold = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" wrote in message
...
Mike,

Cell.Offset(1, 1).Characters(Len(BusinessName) + 1, _
Len(Str(MemberNumber))).Font.Bold = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mikeburg"
wrote
in message
...

I have a variable assigned a value as follows:

Dim MemberNumber As Integer
Dim MemberName as Text
MemberNumber = Cell
MemberName = Cell.Offset(1, 0)
Cell.Offset(1, 1) = BusinessName & " " & MemberNumber

How can I set the member number to be bolded?

Thanks so very 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