Excel Macro to Hide rows based on user input.

[JayRD]

Can anyone tell me what's wrong with this macro.
I want the macro to hide all the rows greater or equal to ct.

Sub Macro2()
'
' Macro2 Macro
'
Dim Atest As Range

ct = Worksheets("Step One").Cells(24, "E").Value
Set Atest = Range(Worksheets("Sheet2").Cells(A, ct), Worksheets("Sheet2").Cells(A, 65536))
Atest.EntireRow.Hidden = True

End Sub

 

[PHV]

Perhaps this ?
Worksheets("Sheet2").Rows(ct & ":65536").Hidden = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JayRD]

PHV,

It didn't work.