scroll window

K

kalpesh

Hello


any idea for scroll window only "H" column
so left column do not shown & scroll only "H" column

how
 
D

Don Guillett

Hello,


any idea for scroll window only "H" column.
so left column do not shown & scroll only "H" column.

how

Sub setscrollarea()
Application.Goto Range("h1"), scroll:=True
ActiveSheet.ScrollArea = ""
ActiveSheet.ScrollArea = "h1:h21"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top