Although your answer is most likely correct, i'm a bit confused with response
probably due to my limited knowledge of VBA. Can you give it another shot in
layman's terms? Thanks.

"Datasort" wrote:

You will need to set the rows().hidden property to false.

Ask the user which row

vtemp = msgbox "which row do you want to unhide


Perform the hidden = false method
if isnumneric (vtemp) then
Rows(vtemp & ":" & vtemp ).Hidden = false


Regards,

Stewart Rogers

"lennyx2" wrote:

Hi,
New to VBA.
Want to unhide rows based on a YES or NO response.
Any help appreciated.
Bob