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
Click to expand...

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