VBA to Hide active row where cursor is

[Crocdundee]

Hi Here I am again, I would like to create a macro to highlight current row and hide the entire row.
I thank you in advance for any help on this , i am using excel 2013
Regards
Graham

 

[ztodd]

highlight:
selection.entirerow.Interior.ColorIndex=?

hide:
selection.entirerow.hidden = true

You can usually guess at things like this by using the "intellisense" of an object- for example, in your code editor, type "range." and you should see a drop-down appear of all the properties of a range object. After you have typed or selected any object / method / property, you can press F1 to get help on how to use it.

 

[Peter_SSs]

Given your thread title, you may want to replace "selection" with "ActiveCell" in the previous suggestion.

 

[Crocdundee]

Big thank you to both of you guys, really appreciate what you guys do here.
Graham