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

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

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