Thread: Mark entire row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yarroll Yarroll is offline
external usenet poster
 
Posts: 3
Default 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