Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mark entire row
Hello,
1) How do I write a macro to mark an entire row based on cursor position? Something like: ActiveCell.EntireRow.Font = Bold or ActiveCell.EntireRow.Font.Bold = True 2) Would it be possible to re-map keyboard functions fr a while (when Excel file is an "active" window). Since typing text in Excel is not very likely in my case, I would very much prefer to run a macro like ActiveCell.EntireRow.Font = Bold by simply hitting "z", "x" or whatever, rather than look for Ctrl + z etc. Thanks for any advice. Yarroll |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mark entire row
Use this code:
Sub BoldRow() Rows(ActiveCell.Row).Select Selection.Font.Bold = True End Sub After you put that in VBA, go to your macro list under Data--Macro, choose BoldRow (or whatever you call it) and you can define a keyboard shortcut for it. I don't think there's a way to make it work without using the CTRL key. Yarroll wrote: Hello, 1) How do I write a macro to mark an entire row based on cursor position? Something like: ActiveCell.EntireRow.Font = Bold or ActiveCell.EntireRow.Font.Bold = True 2) Would it be possible to re-map keyboard functions fr a while (when Excel file is an "active" window). Since typing text in Excel is not very likely in my case, I would very much prefer to run a macro like ActiveCell.EntireRow.Font = Bold by simply hitting "z", "x" or whatever, rather than look for Ctrl + z etc. Thanks for any advice. Yarroll |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mark entire row
Thanks!!! napisal w wiadomosci oups.com... Use this code: Sub BoldRow() Rows(ActiveCell.Row).Select Selection.Font.Bold = True End Sub After you put that in VBA, go to your macro list under Data--Macro, choose BoldRow (or whatever you call it) and you can define a keyboard shortcut for it. I don't think there's a way to make it work without using the CTRL key. Yarroll wrote: Hello, 1) How do I write a macro to mark an entire row based on cursor position? Something like: ActiveCell.EntireRow.Font = Bold or ActiveCell.EntireRow.Font.Bold = True 2) Would it be possible to re-map keyboard functions fr a while (when Excel file is an "active" window). Since typing text in Excel is not very likely in my case, I would very much prefer to run a macro like ActiveCell.EntireRow.Font = Bold by simply hitting "z", "x" or whatever, rather than look for Ctrl + z etc. Thanks for any advice. Yarroll |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The mark is bugging me! LOL | Excel Worksheet Functions | |||
Copy an entire sheet | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
In Excel, can I shade entire rows based on the value of a single . | Excel Worksheet Functions | |||
Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) |