PDA

View Full Version : Whole row of active cell should be bold



GI30065
04-12-2007, 02:09 PM
Hi,

The text of the active cell's row should be displayed BOLD.
In other words, My cursor is on row 8, then this whole row should be bold.
Is this possible ?

Regards,
Marc.

mdmackillop
04-12-2007, 02:21 PM
Hi Mark
Welcome to VBAX
Add the following code to the appropriate worksheet module
Regards
MD


Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
End Sub

mudraker
04-12-2007, 03:34 PM
This question has been posted to at least 2 other sites

lucas
04-12-2007, 08:14 PM
Malcolm gave them a working code....that's why they come here.

GI30065 please read this (http://www.excelguru.ca/node/7)

GI30065
04-13-2007, 01:36 AM
Read the article, won't happen again.
Didn't know that the sites were linked.
I'm Sorry :mkay

lucas
04-13-2007, 05:22 AM
Hi GI,
They are not linked, we just have members that visit multiple sites and happen to see the posts in multiple forums. As the link suggests, there is nothing wrong with it.....we just appreciate a link to any other forum where folks might be making progress or even have already solved your problem before we put much of our own effort into it.

No apology necessary.....we just want you to understand why it helps us.

GI30065
04-13-2007, 12:46 PM
I understand.
I had another q on a different board, and I think the gay who helped me out is now gone to bed. So only if it's not too much to ask, can you please look at it, coz this work has to be done by tommorow.
I think it's a very simple q for you guys.
The very first script is good for me, tried it to edit myself, but it didn't worked.

Best Regards,
Marc.

Sorry, nearly forgot the url, here it is
Had to remove the link coz I had only 2 posts in the past.
What should I do ?

Thx.

mdmackillop
04-13-2007, 12:49 PM
Paste the link text without the http stuff

GI30065
04-13-2007, 12:54 PM
Very smart :yes
Can you answer this q too ?
Why did GOD not give me moorrre brains ?!

Here it is

mrexcel.com/board2/viewtopic.php?t=267436

mdmackillop
04-13-2007, 01:49 PM
Replied in that forum (http://mrexcel.com/board2/viewtopic.php?t=267436)

GI30065
04-13-2007, 02:11 PM
Columns A,B,C and D are just plain text.
Columns E through M can contain any given number between 1 and 5.
And then I have 52 rows, that's all.
Of course the sheet itself is larger, whith a lot of formulas.
But they all work with the numbers in Colums E trough M.
The only thing I want is, when I delete the contens of B3,B4,... to B52.
Excel automatically deletes the according values in cells E trough M.
No strings attachted.
So if I delete the contens of B9, excel should delete the contens of E9 trough M9.
Hope this helps.
I've been working on this file for many weeks, with lots of trouble.
I never worked with excel before, that's why it's so hard for me.

Very Best Regards,
Marc.

mdmackillop
04-13-2007, 02:20 PM
Since your question is in another forum, we should deal with it there.

asingh
04-15-2007, 03:09 AM
Not to throw the thread on a tangent.... I tried the VBA code as MD had mentioned...Now control C is not working on the sheet..any workaround to this...!

mdmackillop
04-15-2007, 03:22 AM
The code should not affect Control + C. Can you post your workbook?

asingh
04-15-2007, 07:49 PM
Here is a sample worksheet....do a control C..then move the cursor...the dotted lines..get disabled..and clipboard is empty........!

rgds