I presume
Cell.Offset(1, 1) = BusinessName & " " & MemberNumber
should be
Cell.Offset(1, 1) = memberName & " " & MemberNumber

I'm not clear which cell you want to make bold, bot one of

Cell.Font.Bold = True
or
Cell.Offset(1,1).Font.Bold = True
should do it.



mikeburg wrote:
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