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.
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.
Hi Mark
Welcome to VBAX
Add the following code to the appropriate worksheet module
Regards
MD
[VBA]
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
This question has been posted to at least 2 other sites
Malcolm gave them a working code....that's why they come here.
GI30065 please read this
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Read the article, won't happen again.
Didn't know that the sites were linked.
I'm Sorry
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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.
Paste the link text without the http stuff
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Very smart
Can you answer this q too ?
Why did GOD not give me moorrre brains ?!
Here it is
mrexcel.com/board2/viewtopic.php?t=267436
Replied in that forum
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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.
Since your question is in another forum, we should deal with it there.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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...!
The code should not affect Control + C. Can you post your workbook?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Here is a sample worksheet....do a control C..then move the cursor...the dotted lines..get disabled..and clipboard is empty........!
rgds